{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","ARRS Summary","ARR Staff","PCN NonARRS","All Funding Streams","IIF","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,15,0,17],[5,1,5,17],[13,1,13,17],[2,13,2,14],[3,13,3,14],[3,15,3,16],[2,15,2,16],[2,3,2,5],[3,3,3,5],[2,8,3,8]]}
[null,{"$f":"D4&\" PCN Funding Stream Calculator and ARRS Tracker 23/24\"","v":" PCN Funding Stream Calculator and ARRS Tracker 23/24"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Developed by Steve Rudd: stephen.rudd@nhs.net"]
[]
[null,null,null,"Dropdown",null,null,null,null,"List Sizes 23/24","Weighted","Actual","Adj'd",null,"Last Updated by PCN:",null,"2023-04-18T11:29:07"]
[null,"Select your PCN:",null,null,null,null,null,null,null,{"$f":"IF(D4=\"\",\"\",VLOOKUP(D4,PCNs[#All],2,FALSE))","v":""},{"$f":"IF(D4=\"\",\"\",VLOOKUP(D4,PCNs[#All],3,FALSE))","v":""},{"$f":"IF(D4=\"\",\"\",VLOOKUP(D4,PCNs[#All],5,FALSE))","v":""},null,"ARR salaries entered up to:",null,{"$f":"'ARRS Summary'!H2","v":"Not Yet Entered"}]
[]
[null,"Workforce"]
[]
[]
[]
[]
[]
[]
[]
[null,"Other Funding"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Copyright © 2022. All Rights Reserved.v3.0, released April 2023\"","v":"Copyright © 2022. All Rights Reserved.v3.0, released April 2023"}]

{"sheet":"ARRS Summary","index":1,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[[21,1,21,3],[21,6,21,7],[27,6,27,7],[27,1,27,3],[29,8,29,13],[26,1,26,3],[26,6,26,7],[28,1,28,3],[28,6,28,7],[22,1,22,3],[22,6,22,7],[24,1,24,3],[24,6,24,7],[25,1,25,3],[25,6,25,7],[23,1,23,3],[30,6,30,7],[31,1,31,3],[31,6,31,7],[29,1,29,3],[29,6,29,7],[18,1,18,3],[18,6,18,7],[19,1,19,3],[19,6,19,7],[20,1,20,3],[15,1,15,3],[15,6,15,7],[16,1,16,3],[16,6,16,7],[17,1,17,3],[17,6,17,7],[14,1,14,3],[14,6,14,7],[3,14,4,15],[3,16,4,16],[3,17,5,17],[10,6,10,7],[12,1,12,3],[12,6,12,7],[13,1,13,3],[13,6,13,7],[3,1,3,2],[10,1,10,3],[1,2,1,3],[2,8,2,16],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,8,4,8],[3,9,4,9],[3,13,4,13],[23,6,23,7],[0,9,0,16],[3,18,5,18],[5,14,5,15],[9,8,9,13],[20,6,20,7]]}
[null,{"$f":"Home!D4&\" ARR Workforce Position and Forecast 23/24\"","v":" ARR Workforce Position and Forecast 23/24"},null,null,null,null,null,null,null,"Developed by Steve Rudd: stephen.rudd@nhs.net"]
[null,null,"Last Updated:",null,"2023-04-18T11:29:07",null,"ARR salaries entered up to:",{"$f":"_xlfn.IFS(I2=12,\"Mar 24\",I2=11,\"Feb 24\",I2=10,\"Jan 24\",I2=9,\"Dec 23\",I2=8,\"Nov 23\",I2=7,\"Oct 23\",I2=6,\"Sept 23\",I2=5,\"Aug 23\",I2=4,\"Jul 23\",I2=3,\"Jun 23\",I2=2,\"May 23\",I2=1,\"Apr 23\",I2=0,\"Not Yet Entered\")","v":"Not Yet Entered"},{"$f":"_xlfn.IFS('ARR Staff'!BY1<>\"\",12,'ARR Staff'!BT1<>\"\",11,'ARR Staff'!BO1<>\"\",10,'ARR Staff'!BJ1<>\"\",9,'ARR Staff'!BE1<>\"\",8,'ARR Staff'!AZ1<>\"\",7,'ARR Staff'!AU1<>\"\",6,'ARR Staff'!AP1<>\"\",5,'ARR Staff'!AK1<>\"\",4,'ARR Staff'!AF1<>\"\",3,'ARR Staff'!AA1<>\"\",2,'ARR Staff'!V1<>\"\",1,'ARR Staff'!V1=\"\",0)","v":0}]
[null,null,null,null,null,null,null,null,"Further 23/24 Analysis"]
[null,"Population",null,"Annual ARR budget","Forecast Spend (based on avg claim)","PCN Forecast Over/Underspend",null,null,{"$f":"\"ARR \nbudget \nYTD \n(\"&_xlfn.IFS(I2=12,\"Mar 24\",I2=11,\"Feb 24\",I2=10,\"Jan 24\",I2=9,\"Dec 23\",I2=8,\"Nov 23\",I2=7,\"Oct 23\",I2=6,\"Sept 23\",I2=5,\"Aug 23\",I2=4,\"Jul 23\",I2=3,\"Jun 23\",I2=2,\"May 23\",I2=1,\"Apr 23\",I2=0,\"N/A\")&\")\"","v":"ARR \nbudget \nYTD \n(N/A)"},{"$f":"\"Spend YTD  (\" & _xlfn.IFS(I2=12,\"Mar 24\",I2=11,\"Feb 24\",I2=10,\"Jan 24\",I2=9,\"Dec 23\",I2=8,\"Nov 23\",I2=7,\"Oct 23\",I2=6,\"Sept 23\",I2=5,\"Aug 23\",I2=4,\"Jul 23\",I2=3,\"Jun 23\",I2=2,\"May 23\",I2=1,\"Apr 23\",I2=0,\"N/A\")&\")\"","v":"Spend YTD  (N/A)"},null,null,null,"Y/E Forecast (latest month)",{"$f":"\"ARR Residual Cost to Practices/PCN YTD (\" & _xlfn.IFS(I2=12,\"Mar 24\",I2=11,\"Feb 24\",I2=10,\"Jan 24\",I2=9,\"Dec 23\",I2=8,\"Nov 23\",I2=7,\"Oct 23\",I2=6,\"Sept 23\",I2=5,\"Aug 23\",I2=4,\"Jul 23\",I2=3,\"Jun 23\",I2=2,\"May 23\",I2=1,\"Apr 23\",I2=0,\"N/A\")&\")\"","v":"ARR Residual Cost to Practices/PCN YTD (N/A)"},null,"Y/E Forecast residual cost"]
[null,"Year","Weighted"]
[null,"2023/24",{"$f":"Home!$J$4","v":""},{"$f":"IF(C6=\"\",\"\",C6*22.671)","v":""},{"$f":"IF(C6=\"\",\"\",IF('ARR Staff'!V1=\"\",SUM(F13:F30),SUM(SUM('ARR Staff'!V1,'ARR Staff'!AA1,'ARR Staff'!AF1,'ARR Staff'!AK1,'ARR Staff'!AP1,'ARR Staff'!AU1,'ARR Staff'!AZ1,'ARR Staff'!BE1,'ARR Staff'!BJ1,'ARR Staff'!BO1,'ARR Staff'!BT1,'ARR Staff'!BY1))/I2*12)+M32)","v":""},{"$f":"IF(C6=\"\",\"\",E6-D6)","v":""},null,null,{"$f":"IF(C6=\"\",\"\",D6/12*I2)","v":""},{"$f":"SUM('ARR Staff'!V1,'ARR Staff'!AA1,'ARR Staff'!AF1,'ARR Staff'!AK1,'ARR Staff'!AP1,'ARR Staff'!AU1,'ARR Staff'!AZ1,'ARR Staff'!BE1,'ARR Staff'!BJ1,'ARR Staff'!BO1,'ARR Staff'!BT1,'ARR Staff'!BY1)","v":0},null,null,null,{"$f":"IF(I2=0,E6,SUM(J6,M32,_xlfn.IFS('ARR Staff'!BY1<>\"\",0,'ARR Staff'!BT1<>\"\",'ARR Staff'!BT1,'ARR Staff'!BO1<>\"\",'ARR Staff'!BO1*2,'ARR Staff'!BJ1<>\"\",'ARR Staff'!BJ1*3,'ARR Staff'!BE1<>\"\",'ARR Staff'!BE1*4,'ARR Staff'!AZ1<>\"\",'ARR Staff'!AZ1*5,'ARR Staff'!AU1<>\"\",'ARR Staff'!AU1*6,'ARR Staff'!AP1<>\"\",'ARR Staff'!AP1*7,'ARR Staff'!AK1<>\"\",'ARR Staff'!AK1*8,'ARR Staff'!AF1<>\"\",'ARR Staff'!AF1*9,'ARR Staff'!AA1<>\"\",'ARR Staff'!AA1*10,'ARR Staff'!V1<>\"\",'ARR Staff'!V1*11)))","v":""},{"$f":"'ARR Staff'!CC1+'ARR Staff'!CB1","v":0},null,{"$f":"IF(I2=0,\"N/A\",O6/I2*12)","v":"N/A"}]
[]
[]
[]
[null,"Workforce Summary - ARRS Staff Currently in Post",null,null,null,null,"Forecast Reductions/Additions",null,"2023/24"]
[null,"Total ARR WTE PCN Roles As At:",null,null,{"$f":"IF(AND('ARR Staff'!C5=\"\",'ARR Staff'!V1=\"\"),H2,IF(AND('ARR Staff'!C5<>\"\",'ARR Staff'!V1=\"\"),\"Apr 23\",H2))","v":"Not Yet Entered"},null,"Additional PCN Role",null,"Change","Month","MthAsNo","In year total","In year cost","New Total"]
[]
[null,"Clinical Pharmacist",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B13,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E13*Data!H4","v":0},"Clinical Pharmacist (B7-8a)",null,null,null,{"$f":"IF(J13=\"\",\"\",IF(J13=\"April\",1,IF(J13=\"May\",0.9167,IF(J13=\"June\",0.8333,IF(J13=\"July\",0.75,IF(J13=\"Aug\",0.67,IF(J13=\"Sept\",0.58333,IF(J13=\"Oct\",0.5,IF(J13=\"Nov\",0.4167,IF(J13=\"Dec\",0.3333,IF(J13=\"Jan\",0.25,IF(J13=\"Feb\",0.1667,0.083)))))))))))*I13)","v":""},{"$f":"IF(I13=\"\",\"\",SUM(E13+K13))","v":""},{"$f":"IF(I13=\"\",\"\",K13*Data!H4)","v":""},{"$f":"E13+I13","v":0}]
[null,"Pharmacy Technician",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B14,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E14*Data!H5","v":0},"Pharmacy Technician (B5)",null,null,null,{"$f":"IF(J14=\"\",\"\",IF(J14=\"April\",1,IF(J14=\"May\",0.9167,IF(J14=\"June\",0.8333,IF(J14=\"July\",0.75,IF(J14=\"Aug\",0.67,IF(J14=\"Sept\",0.58333,IF(J14=\"Oct\",0.5,IF(J14=\"Nov\",0.4167,IF(J14=\"Dec\",0.3333,IF(J14=\"Jan\",0.25,IF(J14=\"Feb\",0.1667,0.083)))))))))))*I14)","v":""},"",{"$f":"IF(I14=\"\",\"\",K14*Data!H5)","v":""},0]
[null,"Paramedic",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B15,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E15*Data!H6","v":0},"Paramedic (B7)",null,null,null,{"$f":"IF(J15=\"\",\"\",IF(J15=\"April\",1,IF(J15=\"May\",0.9167,IF(J15=\"June\",0.8333,IF(J15=\"July\",0.75,IF(J15=\"Aug\",0.67,IF(J15=\"Sept\",0.58333,IF(J15=\"Oct\",0.5,IF(J15=\"Nov\",0.4167,IF(J15=\"Dec\",0.3333,IF(J15=\"Jan\",0.25,IF(J15=\"Feb\",0.1667,0.083)))))))))))*I15)","v":""},"",{"$f":"IF(I15=\"\",\"\",K15*Data!H6)","v":""},0]
[null,"Physiotherapist",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B16,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E16*Data!H7","v":0},"Physiotherapist (B7-8a)",null,null,null,{"$f":"IF(J16=\"\",\"\",IF(J16=\"April\",1,IF(J16=\"May\",0.9167,IF(J16=\"June\",0.8333,IF(J16=\"July\",0.75,IF(J16=\"Aug\",0.67,IF(J16=\"Sept\",0.58333,IF(J16=\"Oct\",0.5,IF(J16=\"Nov\",0.4167,IF(J16=\"Dec\",0.3333,IF(J16=\"Jan\",0.25,IF(J16=\"Feb\",0.1667,0.083)))))))))))*I16)","v":""},"",{"$f":"IF(I16=\"\",\"\",K16*Data!H7)","v":""},0]
[null,"Social Prescribing Link Worker",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B17,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E17*Data!H8","v":0},"Social Prescribing Link Worker (B5)",null,null,null,{"$f":"IF(J17=\"\",\"\",IF(J17=\"April\",1,IF(J17=\"May\",0.9167,IF(J17=\"June\",0.8333,IF(J17=\"July\",0.75,IF(J17=\"Aug\",0.67,IF(J17=\"Sept\",0.58333,IF(J17=\"Oct\",0.5,IF(J17=\"Nov\",0.4167,IF(J17=\"Dec\",0.3333,IF(J17=\"Jan\",0.25,IF(J17=\"Feb\",0.1667,0.083)))))))))))*I17)","v":""},"",{"$f":"IF(I17=\"\",\"\",K17*Data!H8)","v":""},0]
[null,"Care Coordinator",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B18,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E18*Data!H9","v":0},"Care Coordinator (B4)",null,null,null,{"$f":"IF(J18=\"\",\"\",IF(J18=\"April\",1,IF(J18=\"May\",0.9167,IF(J18=\"June\",0.8333,IF(J18=\"July\",0.75,IF(J18=\"Aug\",0.67,IF(J18=\"Sept\",0.58333,IF(J18=\"Oct\",0.5,IF(J18=\"Nov\",0.4167,IF(J18=\"Dec\",0.3333,IF(J18=\"Jan\",0.25,IF(J18=\"Feb\",0.1667,0.083)))))))))))*I18)","v":""},"",{"$f":"IF(I18=\"\",\"\",K18*Data!H9)","v":""},0]
[null,"Health and Wellbeing Coach",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B19,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E19*Data!H10","v":0},"Health and Wellbeing Coach (B5)",null,null,null,{"$f":"IF(J19=\"\",\"\",IF(J19=\"April\",1,IF(J19=\"May\",0.9167,IF(J19=\"June\",0.8333,IF(J19=\"July\",0.75,IF(J19=\"Aug\",0.67,IF(J19=\"Sept\",0.58333,IF(J19=\"Oct\",0.5,IF(J19=\"Nov\",0.4167,IF(J19=\"Dec\",0.3333,IF(J19=\"Jan\",0.25,IF(J19=\"Feb\",0.1667,0.083)))))))))))*I19)","v":""},"",{"$f":"IF(I19=\"\",\"\",K19*Data!H10)","v":""},0]
[null,"Nursing Associate",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B20,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E20*Data!H14","v":0},"Nursing Associate (B4)",null,null,null,{"$f":"IF(J20=\"\",\"\",IF(J20=\"April\",1,IF(J20=\"May\",0.9167,IF(J20=\"June\",0.8333,IF(J20=\"July\",0.75,IF(J20=\"Aug\",0.67,IF(J20=\"Sept\",0.58333,IF(J20=\"Oct\",0.5,IF(J20=\"Nov\",0.4167,IF(J20=\"Dec\",0.3333,IF(J20=\"Jan\",0.25,IF(J20=\"Feb\",0.1667,0.083)))))))))))*I20)","v":""},"",{"$f":"IF(I20=\"\",\"\",K20*Data!H11)","v":""},0]
[null,"Trainee Nursing Associate",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B21,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E21*Data!H16","v":0},"Trainee Nursing Associate (B3)",null,null,null,{"$f":"IF(J21=\"\",\"\",IF(J21=\"April\",1,IF(J21=\"May\",0.9167,IF(J21=\"June\",0.8333,IF(J21=\"July\",0.75,IF(J21=\"Aug\",0.67,IF(J21=\"Sept\",0.58333,IF(J21=\"Oct\",0.5,IF(J21=\"Nov\",0.4167,IF(J21=\"Dec\",0.3333,IF(J21=\"Jan\",0.25,IF(J21=\"Feb\",0.1667,0.083)))))))))))*I21)","v":""},"",{"$f":"IF(I21=\"\",\"\",K21*Data!H12)","v":""},0]
[null,"General Practice Assistant (GPA)",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B22,'ARR Staff'!$P:$P,\"\")","v":0},null,"General Practice Assistant (B4)",null,null,null,{"$f":"IF(J22=\"\",\"\",IF(J22=\"April\",1,IF(J22=\"May\",0.9167,IF(J22=\"June\",0.8333,IF(J22=\"July\",0.75,IF(J22=\"Aug\",0.67,IF(J22=\"Sept\",0.58333,IF(J22=\"Oct\",0.5,IF(J22=\"Nov\",0.4167,IF(J22=\"Dec\",0.3333,IF(J22=\"Jan\",0.25,IF(J22=\"Feb\",0.1667,0.083)))))))))))*I22)","v":""},"",{"$f":"IF(I22=\"\",\"\",K22*Data!H13)","v":""},0]
[null,"Physician Associate",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B23,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E23*Data!H17","v":0},"Physician Associate (B7)",null,null,null,"","",{"$f":"IF(I23=\"\",\"\",K23*Data!H14)","v":""},0]
[null,"Apprentice Physician Associate",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B24,'ARR Staff'!$P:$P,\"\")","v":0},null,"Apprentice Physician Associate (B5)",null,null,null,"","",{"$f":"IF(I24=\"\",\"\",K24*Data!H15)","v":""},0]
[null,"Occupational Therapists",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B25,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E25*Data!H18","v":0},"Occupational Therapists (B7)",null,null,null,"","",{"$f":"IF(I25=\"\",\"\",K25*Data!H16)","v":""},0]
[null,"Dietitians",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B26,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E26*Data!H11","v":0},"Dietitians (B7)",null,null,null,"","",{"$f":"IF(I26=\"\",\"\",K26*Data!H17)","v":""},0]
[null,"Podiatrists",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B27,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E27*Data!H12","v":0},"Podiatrists (B7)",null,null,null,"","",{"$f":"IF(I27=\"\",\"\",K27*Data!H18)","v":""},0]
[null,"Digital Transformation Lead",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B28,'ARR Staff'!$P:$P,\"\")","v":0},null,"Digital Transformation Lead (B8a)",null,null,null,{"$f":"IF(J28=\"\",\"\",IF(J28=\"April\",1,IF(J28=\"May\",0.9167,IF(J28=\"June\",0.8333,IF(J28=\"July\",0.75,IF(J28=\"Aug\",0.67,IF(J28=\"Sept\",0.58333,IF(J28=\"Oct\",0.5,IF(J28=\"Nov\",0.4167,IF(J28=\"Dec\",0.3333,IF(J28=\"Jan\",0.25,IF(J28=\"Feb\",0.1667,0.083)))))))))))*I28)","v":""},"",{"$f":"IF(I28=\"\",\"\",K28*Data!H19)","v":""},0]
[null,"Advanced Practitioner",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B29,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E29*Data!H19","v":0},"Advanced Practitioner (B8a)",null,null,null,"","",{"$f":"IF(I29=\"\",\"\",K29*Data!H19)","v":""},0]
[null,"Mental Health Practitioner",null,null,{"$f":"SUMIFS('ARR Staff'!$N:$N,'ARR Staff'!$I:$I,'ARRS Summary'!B30,'ARR Staff'!$P:$P,\"\")","v":0},{"$f":"E30*Data!H21/2","v":0},"Mental Health Practitioner - Select band: "]
[null,null,null,null,null,null,"Mental Health Practitioner (B4-8a)",null,null,null,{"$f":"IF(J31=\"\",\"\",IF(J31=\"April\",1,IF(J31=\"May\",0.9167,IF(J31=\"June\",0.8333,IF(J31=\"July\",0.75,IF(J31=\"Aug\",0.67,IF(J31=\"Sept\",0.58333,IF(J31=\"Oct\",0.5,IF(J31=\"Nov\",0.4167,IF(J31=\"Dec\",0.3333,IF(J31=\"Jan\",0.25,IF(J31=\"Feb\",0.1667,0.083)))))))))))*I31)","v":""},{"$f":"SUM(E30+I31)","v":0},{"$f":"IF(I31=\"\",\"\",_xlfn.IFS(I30=Data!$B$4,Data!H11,I30=Data!B5,Data!H5,I30=Data!B6,Data!H21,I30=Data!B7,Data!H18,I30=Data!B8,Data!H19)*K31/2)","v":""},{"$f":"E30+I31","v":0}]
[null,"Total ARR WTE Roles:",null,null,{"$f":"SUM(E13:E30)","v":0},null,"Total ARR WTE Roles:",null,{"$f":"SUM(I13:I29,I31)","v":0},null,null,null,{"$f":"SUM(M13:M29,M31)","v":0},{"$f":"SUM(N13:N29,N31)","v":0}]

{"sheet":"ARR Staff","index":2,"n_rows":105,"n_cols":82,"rows_kept":105,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,4,0,5],[1,77,2,80],[2,37,2,41],[2,42,2,46],[2,47,2,51],[2,52,2,56],[1,8,2,8],[1,9,2,9],[1,13,2,13],[1,15,2,15],[1,16,2,16],[2,17,2,21],[2,22,2,26],[2,27,2,31],[2,32,2,36],[2,1,2,7],[2,67,2,71],[2,72,2,76],[2,57,2,61],[2,62,2,66]]}
[null,"ARR Staff",null,null,"* = mandatory fields",null,null,null,null,null,null,null,null,null,null,null,"TOTALS",{"$f":"IF(SUM(R4:R1000)=0,0,SUM(R4:R1000))","v":0},{"$f":"IF(SUM(S4:S1000)=0,0,SUM(S4:S1000))","v":0},0,0,{"$f":"IF(R1=0,\"\",IF(SUM(V4:V1000)=0,0,SUM(V4:V1000)))","v":""},{"$f":"IF(SUM(W4:W1000)=0,0,SUM(W4:W1000))","v":0},{"$f":"IF(SUM(X4:X1000)=0,0,SUM(X4:X1000))","v":0},0,0,{"$f":"IF(W1=0,\"\",IF(SUM(AA4:AA1000)=0,0,SUM(AA4:AA1000)))","v":""},{"$f":"IF(SUM(AB4:AB1000)=0,0,SUM(AB4:AB1000))","v":0},{"$f":"IF(SUM(AC4:AC1000)=0,0,SUM(AC4:AC1000))","v":0},0,0,{"$f":"IF(AB1=0,\"\",IF(SUM(AF4:AF1000)=0,0,SUM(AF4:AF1000)))","v":""},{"$f":"IF(SUM(AG4:AG1000)=0,0,SUM(AG4:AG1000))","v":0},{"$f":"IF(SUM(AH4:AH1000)=0,0,SUM(AH4:AH1000))","v":0},0,0,{"$f":"IF(AG1=0,\"\",IF(SUM(AK4:AK1000)=0,0,SUM(AK4:AK1000)))","v":""},{"$f":"IF(SUM(AL4:AL1000)=0,0,SUM(AL4:AL1000))","v":0},{"$f":"IF(SUM(AM4:AM1000)=0,0,SUM(AM4:AM1000))","v":0},0,0,{"$f":"IF(AL1=0,\"\",IF(SUM(AP4:AP1000)=0,0,SUM(AP4:AP1000)))","v":""},{"$f":"IF(SUM(AQ4:AQ1000)=0,0,SUM(AQ4:AQ1000))","v":0},{"$f":"IF(SUM(AR4:AR1000)=0,0,SUM(AR4:AR1000))","v":0},0,0,{"$f":"IF(AQ1=0,\"\",IF(SUM(AU4:AU1000)=0,0,SUM(AU4:AU1000)))","v":""},{"$f":"IF(SUM(AV4:AV1000)=0,0,SUM(AV4:AV1000))","v":0},{"$f":"IF(SUM(AW4:AW1000)=0,0,SUM(AW4:AW1000))","v":0},0,0,{"$f":"IF(AV1=0,\"\",IF(SUM(AZ4:AZ1000)=0,0,SUM(AZ4:AZ1000)))","v":""},{"$f":"IF(SUM(BA4:BA1000)=0,0,SUM(BA4:BA1000))","v":0},{"$f":"IF(SUM(BB4:BB1000)=0,0,SUM(BB4:BB1000))","v":0},0,0,{"$f":"IF(BA1=0,\"\",IF(SUM(BE4:BE1000)=0,0,SUM(BE4:BE1000)))","v":""},{"$f":"IF(SUM(BF4:BF1000)=0,0,SUM(BF4:BF1000))","v":0},{"$f":"IF(SUM(BG4:BG1000)=0,0,SUM(BG4:BG1000))","v":0},0,0,{"$f":"IF(BF1=0,\"\",IF(SUM(BJ4:BJ1000)=0,0,SUM(BJ4:BJ1000)))","v":""},{"$f":"IF(SUM(BK4:BK1000)=0,0,SUM(BK4:BK1000))","v":0},{"$f":"IF(SUM(BL4:BL1000)=0,0,SUM(BL4:BL1000))","v":0},0,0,{"$f":"IF(BK1=0,\"\",IF(SUM(BO4:BO1000)=0,0,SUM(BO4:BO1000)))","v":""},{"$f":"IF(SUM(BP4:BP1000)=0,0,SUM(BP4:BP1000))","v":0},{"$f":"IF(SUM(BQ4:BQ1000)=0,0,SUM(BQ4:BQ1000))","v":0},0,0,{"$f":"IF(BP1=0,\"\",IF(SUM(BT4:BT1000)=0,0,SUM(BT4:BT1000)))","v":""},{"$f":"IF(SUM(BU4:BU1000)=0,0,SUM(BU4:BU1000))","v":0},{"$f":"IF(SUM(BV4:BV1000)=0,0,SUM(BV4:BV1000))","v":0},0,0,{"$f":"IF(BU1=0,\"\",IF(SUM(BY4:BY1000)=0,0,SUM(BY4:BY1000)))","v":""},{"$f":"IF(SUM(BZ4:BZ1000)=0,0,SUM(BZ4:BZ1000))","v":0},{"$f":"IF(SUM(CA4:CA1000)=0,0,SUM(CA4:CA1000))","v":0},0,0]
[null,null,null,null,null,null,null,null,"Dropdown","Conditional dropdown",null,null,null,"Calculated",null,"Enter when employee left","Calculated","Enter","Calculated","Enter","Calculated","Enter","Enter","Calculated","Enter","Calculated","Enter","Enter","Calculated","Enter","Calculated","Enter","Enter","Calculated","Enter","Calculated","Enter","Enter","Calculated","Enter","Calculated","Enter","Enter","Enter","Enter","Calculated","Enter","Enter","Calculated","Enter","Calculated","Enter","Enter","Calculated","Enter","Calculated","Enter","Enter","Calculated","Enter","Calculated","Enter","Enter","Calculated","Enter","Calculated","Enter","Enter","Calculated","Enter","Calculated","Enter","Enter","Calculated","Enter","Calculated","Enter","Calculated Totals"]
[null,"Optional Fields",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April",null,null,null,null,"May",null,null,null,null,"June",null,null,null,null,"July",null,null,null,null,"August",null,null,null,null,"September",null,null,null,null,"October",null,null,null,null,"November",null,null,null,null,"December",null,null,null,null,"January",null,null,null,null,"February",null,null,null,null,"March"]
[null,"Name","ARR Portal Code Ref*","Appraisal Date 23/24","Line Manager","Clinical Supervisor & Support","Employer","Works At","Role*","MH ARR A4C Band*","Non MH salary","MH salary","Current hours/week*","Current WTE","PCN Start Date*","PCN End Date*","Monthly Max Reimbursable 23/24 (Latest)","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","Actual Salary (+SPLW fee)*","Above ARR Claim","Other (non-reimbursable)","Indicative Portal Value","Actual Portal Reimbursement*","ARRS income YTD TOTAL","Above ARR TOTAL","Non-reimbursable TOTAL","Residual cost to PCN","Comments"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I5=\"\",\"\",IF(I5='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I5,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I5<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J5=Data!$B$4,Data!$H$11,J5=Data!$B$5,Data!$H$5,J5=Data!$B$6,Data!$H$21,J5=Data!$B$7,Data!$H$6,J5=Data!$B$8,Data!$H$19))","v":""},null,{"$f":"IF(M5=\"\",\"\",M5/37.5)","v":""},null,null,{"$f":"IF(I5=\"\",\"\",IF(I5='ARRS Summary'!B$30,L5/2,K5)/12*N5)","v":""},null,{"$f":"IF(R5=\"\",\"\",IF(R5<V5,0,R5-V5))","v":""},null,{"$f":"IF(R5=\"\",\"\",MIN(R5,$Q5))","v":""},{"$f":"IF(R5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(W5=\"\",\"\",IF(W5<AA5,0,W5-AA5))","v":""},null,{"$f":"IF(W5=\"\",\"\",MIN(W5,$Q5))","v":""},{"$f":"IF(W5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(AB5=\"\",\"\",IF(AB5<AF5,0,AB5-AF5))","v":""},null,{"$f":"IF(AB5=\"\",\"\",MIN(AB5,$Q5))","v":""},{"$f":"IF(AB5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(AG5=\"\",\"\",IF(AG5<AK5,0,AG5-AK5))","v":""},null,{"$f":"IF(AG5=\"\",\"\",MIN(AG5,$Q5))","v":""},{"$f":"IF(AG5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(AL5=\"\",\"\",IF(AL5<AP5,0,AL5-AP5))","v":""},null,{"$f":"IF(AL5=\"\",\"\",MIN(AL5,$Q5))","v":""},{"$f":"IF(AL5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(AQ5=\"\",\"\",IF(AQ5<AU5,0,AQ5-AU5))","v":""},null,{"$f":"IF(AQ5=\"\",\"\",MIN(AQ5,$Q5))","v":""},{"$f":"IF(AQ5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(AV5=\"\",\"\",IF(AV5<AZ5,0,AV5-AZ5))","v":""},null,{"$f":"IF(AV5=\"\",\"\",MIN(AV5,$Q5))","v":""},{"$f":"IF(AV5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(BA5=\"\",\"\",IF(BA5<BE5,0,BA5-BE5))","v":""},null,{"$f":"IF(BA5=\"\",\"\",MIN(BA5,$Q5))","v":""},{"$f":"IF(BA5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(BF5=\"\",\"\",IF(BF5<BJ5,0,BF5-BJ5))","v":""},null,{"$f":"IF(BF5=\"\",\"\",MIN(BF5,$Q5))","v":""},{"$f":"IF(BF5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(BK5=\"\",\"\",IF(BK5<BO5,0,BK5-BO5))","v":""},null,{"$f":"IF(BK5=\"\",\"\",MIN(BK5,$Q5))","v":""},{"$f":"IF(BK5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(BP5=\"\",\"\",IF(BP5<BT5,0,BP5-BT5))","v":""},null,{"$f":"IF(BP5=\"\",\"\",MIN(BP5,$Q5))","v":""},{"$f":"IF(BP5=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(BU5=\"\",\"\",IF(BU5<BY5,0,BU5-BY5))","v":""},null,{"$f":"IF(BU5=\"\",\"\",MIN(BU5,$Q5))","v":""},{"$f":"IF(BU5=\"\",\"\",\"Please enter to match portal\")","v":""},{"$f":"IF(I5=\"\",\"\",SUM(V5,AA5,AF5,AK5,AP5,AU5,AZ5,BE5,BJ5,BO5,BT5,BY5))","v":""},{"$f":"IF(I5=\"\",\"\",SUM(S5,X5,AC5,AH5,AM5,AR5,AW5,BB5,BG5,BL5,BQ5,BV5))","v":""},{"$f":"IF(I5=\"\",\"\",SUM(T5,Y5,AD5,AI5,AN5,AS5,AX5,BC5,BH5,BM5,BR5,BW5))","v":""},{"$f":"IF(I5=\"\",\"\",SUM(CA5,CB5))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I6=\"\",\"\",IF(I6='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I6,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I6<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J6=Data!$B$4,Data!$H$11,J6=Data!$B$5,Data!$H$5,J6=Data!$B$6,Data!$H$21,J6=Data!$B$7,Data!$H$6,J6=Data!$B$8,Data!$H$19))","v":""},null,{"$f":"IF(M6=\"\",\"\",M6/37.5)","v":""},null,null,{"$f":"IF(I6=\"\",\"\",IF(I6='ARRS Summary'!B$30,L6/2,K6)/12*N6)","v":""},null,{"$f":"IF(R6=\"\",\"\",IF(R6<V6,0,R6-V6))","v":""},null,{"$f":"IF(R6=\"\",\"\",MIN(R6,$Q6))","v":""},"",null,{"$f":"IF(W6=\"\",\"\",IF(W6<AA6,0,W6-AA6))","v":""},null,{"$f":"IF(W6=\"\",\"\",MIN(W6,$Q6))","v":""},"",null,{"$f":"IF(AB6=\"\",\"\",IF(AB6<AF6,0,AB6-AF6))","v":""},null,{"$f":"IF(AB6=\"\",\"\",MIN(AB6,$Q6))","v":""},{"$f":"IF(AB6=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(AG6=\"\",\"\",IF(AG6<AK6,0,AG6-AK6))","v":""},null,{"$f":"IF(AG6=\"\",\"\",MIN(AG6,$Q6))","v":""},{"$f":"IF(AG6=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(AL6=\"\",\"\",IF(AL6<AP6,0,AL6-AP6))","v":""},null,{"$f":"IF(AL6=\"\",\"\",MIN(AL6,$Q6))","v":""},{"$f":"IF(AL6=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(AQ6=\"\",\"\",IF(AQ6<AU6,0,AQ6-AU6))","v":""},null,{"$f":"IF(AQ6=\"\",\"\",MIN(AQ6,$Q6))","v":""},{"$f":"IF(AQ6=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(AV6=\"\",\"\",IF(AV6<AZ6,0,AV6-AZ6))","v":""},null,{"$f":"IF(AV6=\"\",\"\",MIN(AV6,$Q6))","v":""},{"$f":"IF(AV6=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(BA6=\"\",\"\",IF(BA6<BE6,0,BA6-BE6))","v":""},null,{"$f":"IF(BA6=\"\",\"\",MIN(BA6,$Q6))","v":""},{"$f":"IF(BA6=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(BF6=\"\",\"\",IF(BF6<BJ6,0,BF6-BJ6))","v":""},null,{"$f":"IF(BF6=\"\",\"\",MIN(BF6,$Q6))","v":""},{"$f":"IF(BF6=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(BK6=\"\",\"\",IF(BK6<BO6,0,BK6-BO6))","v":""},null,{"$f":"IF(BK6=\"\",\"\",MIN(BK6,$Q6))","v":""},{"$f":"IF(BK6=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(BP6=\"\",\"\",IF(BP6<BT6,0,BP6-BT6))","v":""},null,{"$f":"IF(BP6=\"\",\"\",MIN(BP6,$Q6))","v":""},{"$f":"IF(BP6=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(BU6=\"\",\"\",IF(BU6<BY6,0,BU6-BY6))","v":""},null,{"$f":"IF(BU6=\"\",\"\",MIN(BU6,$Q6))","v":""},{"$f":"IF(BU6=\"\",\"\",\"Please enter to match portal\")","v":""},{"$f":"IF(I6=\"\",\"\",SUM(V6,AA6,AF6,AK6,AP6,AU6,AZ6,BE6,BJ6,BO6,BT6,BY6))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(S6,X6,AC6,AH6,AM6,AR6,AW6,BB6,BG6,BL6,BQ6,BV6))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(T6,Y6,AD6,AI6,AN6,AS6,AX6,BC6,BH6,BM6,BR6,BW6))","v":""},{"$f":"IF(I6=\"\",\"\",SUM(CA6,CB6))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I7=\"\",\"\",IF(I7='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I7,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I7<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J7=Data!$B$4,Data!$H$11,J7=Data!$B$5,Data!$H$5,J7=Data!$B$6,Data!$H$21,J7=Data!$B$7,Data!$H$6,J7=Data!$B$8,Data!$H$19))","v":""},null,{"$f":"IF(M7=\"\",\"\",M7/37.5)","v":""},null,null,{"$f":"IF(I7=\"\",\"\",IF(I7='ARRS Summary'!B$30,L7/2,K7)/12*N7)","v":""},null,"",null,{"$f":"IF(R7=\"\",\"\",MIN(R7,$Q7))","v":""},"",null,"",null,{"$f":"IF(W7=\"\",\"\",MIN(W7,$Q7))","v":""},"",null,"",null,{"$f":"IF(AB7=\"\",\"\",MIN(AB7,$Q7))","v":""},{"$f":"IF(AB7=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(AG7=\"\",\"\",MIN(AG7,$Q7))","v":""},{"$f":"IF(AG7=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(AL7=\"\",\"\",MIN(AL7,$Q7))","v":""},{"$f":"IF(AL7=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,"","",null,"",null,{"$f":"IF(AV7=\"\",\"\",MIN(AV7,$Q7))","v":""},{"$f":"IF(AV7=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(BA7=\"\",\"\",MIN(BA7,$Q7))","v":""},{"$f":"IF(BA7=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(BF7=\"\",\"\",MIN(BF7,$Q7))","v":""},{"$f":"IF(BF7=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(BK7=\"\",\"\",MIN(BK7,$Q7))","v":""},{"$f":"IF(BK7=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(BP7=\"\",\"\",MIN(BP7,$Q7))","v":""},{"$f":"IF(BP7=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(BU7=\"\",\"\",MIN(BU7,$Q7))","v":""},{"$f":"IF(BU7=\"\",\"\",\"Please enter to match portal\")","v":""},"",{"$f":"IF(I7=\"\",\"\",SUM(S7,X7,AC7,AH7,AM7,AR7,AW7,BB7,BG7,BL7,BQ7,BV7))","v":""},{"$f":"IF(I7=\"\",\"\",SUM(T7,Y7,AD7,AI7,AN7,AS7,AX7,BC7,BH7,BM7,BR7,BW7))","v":""},{"$f":"IF(I7=\"\",\"\",SUM(CA7,CB7))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I8=\"\",\"\",IF(I8='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I8,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I8<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J8=Data!$B$4,Data!$H$11,J8=Data!$B$5,Data!$H$5,J8=Data!$B$6,Data!$H$21,J8=Data!$B$7,Data!$H$6,J8=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I8=\"\",\"\",IF(I8='ARRS Summary'!B$30,L8/2,K8)/12*N8)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",{"$f":"IF(I8=\"\",\"\",SUM(CA8,CB8))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I9=\"\",\"\",IF(I9='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I9,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I9<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J9=Data!$B$4,Data!$H$11,J9=Data!$B$5,Data!$H$5,J9=Data!$B$6,Data!$H$21,J9=Data!$B$7,Data!$H$6,J9=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I9=\"\",\"\",IF(I9='ARRS Summary'!B$30,L9/2,K9)/12*N9)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",{"$f":"IF(I9=\"\",\"\",SUM(CA9,CB9))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I10=\"\",\"\",IF(I10='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I10,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I10<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J10=Data!$B$4,Data!$H$11,J10=Data!$B$5,Data!$H$5,J10=Data!$B$6,Data!$H$21,J10=Data!$B$7,Data!$H$6,J10=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I10=\"\",\"\",IF(I10='ARRS Summary'!B$30,L10/2,K10)/12*N10)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I11=\"\",\"\",IF(I11='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I11,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I11<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J11=Data!$B$4,Data!$H$11,J11=Data!$B$5,Data!$H$5,J11=Data!$B$6,Data!$H$21,J11=Data!$B$7,Data!$H$6,J11=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I11=\"\",\"\",IF(I11='ARRS Summary'!B$30,L11/2,K11)/12*N11)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I12=\"\",\"\",IF(I12='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I12,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I12<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J12=Data!$B$4,Data!$H$11,J12=Data!$B$5,Data!$H$5,J12=Data!$B$6,Data!$H$21,J12=Data!$B$7,Data!$H$6,J12=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I12=\"\",\"\",IF(I12='ARRS Summary'!B$30,L12/2,K12)/12*N12)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",{"$f":"IF(I12=\"\",\"\",SUM(CA12,CB12))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I13=\"\",\"\",IF(I13='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I13,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I13<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J13=Data!$B$4,Data!$H$11,J13=Data!$B$5,Data!$H$5,J13=Data!$B$6,Data!$H$21,J13=Data!$B$7,Data!$H$6,J13=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I13=\"\",\"\",IF(I13='ARRS Summary'!B$30,L13/2,K13)/12*N13)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",{"$f":"IF(I13=\"\",\"\",SUM(CA13,CB13))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I14=\"\",\"\",IF(I14='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I14,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I14<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J14=Data!$B$4,Data!$H$11,J14=Data!$B$5,Data!$H$5,J14=Data!$B$6,Data!$H$21,J14=Data!$B$7,Data!$H$6,J14=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I14=\"\",\"\",IF(I14='ARRS Summary'!B$30,L14/2,K14)/12*N14)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",{"$f":"IF(I14=\"\",\"\",SUM(CA14,CB14))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I15=\"\",\"\",IF(I15='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I15,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I15<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J15=Data!$B$4,Data!$H$11,J15=Data!$B$5,Data!$H$5,J15=Data!$B$6,Data!$H$21,J15=Data!$B$7,Data!$H$6,J15=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I15=\"\",\"\",IF(I15='ARRS Summary'!B$30,L15/2,K15)/12*N15)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",{"$f":"IF(I15=\"\",\"\",SUM(CA15,CB15))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I16=\"\",\"\",IF(I16='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I16,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I16<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J16=Data!$B$4,Data!$H$11,J16=Data!$B$5,Data!$H$5,J16=Data!$B$6,Data!$H$21,J16=Data!$B$7,Data!$H$6,J16=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I16=\"\",\"\",IF(I16='ARRS Summary'!B$30,L16/2,K16)/12*N16)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",{"$f":"IF(I16=\"\",\"\",SUM(CA16,CB16))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I17=\"\",\"\",IF(I17='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I17,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I17<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J17=Data!$B$4,Data!$H$11,J17=Data!$B$5,Data!$H$5,J17=Data!$B$6,Data!$H$21,J17=Data!$B$7,Data!$H$6,J17=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I17=\"\",\"\",IF(I17='ARRS Summary'!B$30,L17/2,K17)/12*N17)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I18=\"\",\"\",IF(I18='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I18,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I18<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J18=Data!$B$4,Data!$H$11,J18=Data!$B$5,Data!$H$5,J18=Data!$B$6,Data!$H$21,J18=Data!$B$7,Data!$H$6,J18=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I18=\"\",\"\",IF(I18='ARRS Summary'!B$30,L18/2,K18)/12*N18)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I19=\"\",\"\",IF(I19='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I19,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I19<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J19=Data!$B$4,Data!$H$11,J19=Data!$B$5,Data!$H$5,J19=Data!$B$6,Data!$H$21,J19=Data!$B$7,Data!$H$6,J19=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I19=\"\",\"\",IF(I19='ARRS Summary'!B$30,L19/2,K19)/12*N19)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I20=\"\",\"\",IF(I20='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I20,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I20<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J20=Data!$B$4,Data!$H$11,J20=Data!$B$5,Data!$H$5,J20=Data!$B$6,Data!$H$21,J20=Data!$B$7,Data!$H$6,J20=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I20=\"\",\"\",IF(I20='ARRS Summary'!B$30,L20/2,K20)/12*N20)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",{"$f":"IF(I20=\"\",\"\",SUM(CA20,CB20))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I21=\"\",\"\",IF(I21='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I21,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I21<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J21=Data!$B$4,Data!$H$11,J21=Data!$B$5,Data!$H$5,J21=Data!$B$6,Data!$H$21,J21=Data!$B$7,Data!$H$6,J21=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I21=\"\",\"\",IF(I21='ARRS Summary'!B$30,L21/2,K21)/12*N21)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I22=\"\",\"\",IF(I22='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I22,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I22<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J22=Data!$B$4,Data!$H$11,J22=Data!$B$5,Data!$H$5,J22=Data!$B$6,Data!$H$21,J22=Data!$B$7,Data!$H$6,J22=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I22=\"\",\"\",IF(I22='ARRS Summary'!B$30,L22/2,K22)/12*N22)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I23=\"\",\"\",IF(I23='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I23,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I23<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J23=Data!$B$4,Data!$H$11,J23=Data!$B$5,Data!$H$5,J23=Data!$B$6,Data!$H$21,J23=Data!$B$7,Data!$H$6,J23=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I23=\"\",\"\",IF(I23='ARRS Summary'!B$30,L23/2,K23)/12*N23)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I24=\"\",\"\",IF(I24='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I24,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I24<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J24=Data!$B$4,Data!$H$11,J24=Data!$B$5,Data!$H$5,J24=Data!$B$6,Data!$H$21,J24=Data!$B$7,Data!$H$6,J24=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I24=\"\",\"\",IF(I24='ARRS Summary'!B$30,L24/2,K24)/12*N24)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I25=\"\",\"\",IF(I25='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I25,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I25<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J25=Data!$B$4,Data!$H$11,J25=Data!$B$5,Data!$H$5,J25=Data!$B$6,Data!$H$21,J25=Data!$B$7,Data!$H$6,J25=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I25=\"\",\"\",IF(I25='ARRS Summary'!B$30,L25/2,K25)/12*N25)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I26=\"\",\"\",IF(I26='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I26,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I26<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J26=Data!$B$4,Data!$H$11,J26=Data!$B$5,Data!$H$5,J26=Data!$B$6,Data!$H$21,J26=Data!$B$7,Data!$H$6,J26=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I26=\"\",\"\",IF(I26='ARRS Summary'!B$30,L26/2,K26)/12*N26)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I27=\"\",\"\",IF(I27='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I27,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I27<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J27=Data!$B$4,Data!$H$11,J27=Data!$B$5,Data!$H$5,J27=Data!$B$6,Data!$H$21,J27=Data!$B$7,Data!$H$6,J27=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I27=\"\",\"\",IF(I27='ARRS Summary'!B$30,L27/2,K27)/12*N27)","v":""},null,"",null,"","",null,"",null,"","",null,{"$f":"IF(AB27=\"\",\"\",IF(AB27<$Q27,0,AB27-AF27))","v":""},null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I28=\"\",\"\",IF(I28='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I28,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I28<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J28=Data!$B$4,Data!$H$11,J28=Data!$B$5,Data!$H$5,J28=Data!$B$6,Data!$H$21,J28=Data!$B$7,Data!$H$6,J28=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I28=\"\",\"\",IF(I28='ARRS Summary'!B$30,L28/2,K28)/12*N28)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I29=\"\",\"\",IF(I29='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I29,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I29<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J29=Data!$B$4,Data!$H$11,J29=Data!$B$5,Data!$H$5,J29=Data!$B$6,Data!$H$21,J29=Data!$B$7,Data!$H$6,J29=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I29=\"\",\"\",IF(I29='ARRS Summary'!B$30,L29/2,K29)/12*N29)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I30=\"\",\"\",IF(I30='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I30,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I30<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J30=Data!$B$4,Data!$H$11,J30=Data!$B$5,Data!$H$5,J30=Data!$B$6,Data!$H$21,J30=Data!$B$7,Data!$H$6,J30=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I30=\"\",\"\",IF(I30='ARRS Summary'!B$30,L30/2,K30)/12*N30)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I31=\"\",\"\",IF(I31='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I31,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I31<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J31=Data!$B$4,Data!$H$11,J31=Data!$B$5,Data!$H$5,J31=Data!$B$6,Data!$H$21,J31=Data!$B$7,Data!$H$6,J31=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I31=\"\",\"\",IF(I31='ARRS Summary'!B$30,L31/2,K31)/12*N31)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I32=\"\",\"\",IF(I32='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I32,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I32<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J32=Data!$B$4,Data!$H$11,J32=Data!$B$5,Data!$H$5,J32=Data!$B$6,Data!$H$21,J32=Data!$B$7,Data!$H$6,J32=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I32=\"\",\"\",IF(I32='ARRS Summary'!B$30,L32/2,K32)/12*N32)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I33=\"\",\"\",IF(I33='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I33,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I33<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J33=Data!$B$4,Data!$H$11,J33=Data!$B$5,Data!$H$5,J33=Data!$B$6,Data!$H$21,J33=Data!$B$7,Data!$H$6,J33=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I33=\"\",\"\",IF(I33='ARRS Summary'!B$30,L33/2,K33)/12*N33)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I34=\"\",\"\",IF(I34='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I34,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I34<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J34=Data!$B$4,Data!$H$11,J34=Data!$B$5,Data!$H$5,J34=Data!$B$6,Data!$H$21,J34=Data!$B$7,Data!$H$6,J34=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I34=\"\",\"\",IF(I34='ARRS Summary'!B$30,L34/2,K34)/12*N34)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I35=\"\",\"\",IF(I35='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I35,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I35<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J35=Data!$B$4,Data!$H$11,J35=Data!$B$5,Data!$H$5,J35=Data!$B$6,Data!$H$21,J35=Data!$B$7,Data!$H$6,J35=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I35=\"\",\"\",IF(I35='ARRS Summary'!B$30,L35/2,K35)/12*N35)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I36=\"\",\"\",IF(I36='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I36,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I36<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J36=Data!$B$4,Data!$H$11,J36=Data!$B$5,Data!$H$5,J36=Data!$B$6,Data!$H$21,J36=Data!$B$7,Data!$H$6,J36=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I36=\"\",\"\",IF(I36='ARRS Summary'!B$30,L36/2,K36)/12*N36)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I37=\"\",\"\",IF(I37='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I37,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I37<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J37=Data!$B$4,Data!$H$11,J37=Data!$B$5,Data!$H$5,J37=Data!$B$6,Data!$H$21,J37=Data!$B$7,Data!$H$6,J37=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I37=\"\",\"\",IF(I37='ARRS Summary'!B$30,L37/2,K37)/12*N37)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I38=\"\",\"\",IF(I38='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I38,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I38<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J38=Data!$B$4,Data!$H$11,J38=Data!$B$5,Data!$H$5,J38=Data!$B$6,Data!$H$21,J38=Data!$B$7,Data!$H$6,J38=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I38=\"\",\"\",IF(I38='ARRS Summary'!B$30,L38/2,K38)/12*N38)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I39=\"\",\"\",IF(I39='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I39,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I39<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J39=Data!$B$4,Data!$H$11,J39=Data!$B$5,Data!$H$5,J39=Data!$B$6,Data!$H$21,J39=Data!$B$7,Data!$H$6,J39=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I39=\"\",\"\",IF(I39='ARRS Summary'!B$30,L39/2,K39)/12*N39)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I40=\"\",\"\",IF(I40='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I40,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I40<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J40=Data!$B$4,Data!$H$11,J40=Data!$B$5,Data!$H$5,J40=Data!$B$6,Data!$H$21,J40=Data!$B$7,Data!$H$6,J40=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I40=\"\",\"\",IF(I40='ARRS Summary'!B$30,L40/2,K40)/12*N40)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I41=\"\",\"\",IF(I41='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I41,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I41<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J41=Data!$B$4,Data!$H$11,J41=Data!$B$5,Data!$H$5,J41=Data!$B$6,Data!$H$21,J41=Data!$B$7,Data!$H$6,J41=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I41=\"\",\"\",IF(I41='ARRS Summary'!B$30,L41/2,K41)/12*N41)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I42=\"\",\"\",IF(I42='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I42,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I42<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J42=Data!$B$4,Data!$H$11,J42=Data!$B$5,Data!$H$5,J42=Data!$B$6,Data!$H$21,J42=Data!$B$7,Data!$H$6,J42=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I42=\"\",\"\",IF(I42='ARRS Summary'!B$30,L42/2,K42)/12*N42)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I43=\"\",\"\",IF(I43='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I43,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I43<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J43=Data!$B$4,Data!$H$11,J43=Data!$B$5,Data!$H$5,J43=Data!$B$6,Data!$H$21,J43=Data!$B$7,Data!$H$6,J43=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I43=\"\",\"\",IF(I43='ARRS Summary'!B$30,L43/2,K43)/12*N43)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I44=\"\",\"\",IF(I44='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I44,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I44<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J44=Data!$B$4,Data!$H$11,J44=Data!$B$5,Data!$H$5,J44=Data!$B$6,Data!$H$21,J44=Data!$B$7,Data!$H$6,J44=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I44=\"\",\"\",IF(I44='ARRS Summary'!B$30,L44/2,K44)/12*N44)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I45=\"\",\"\",IF(I45='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I45,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I45<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J45=Data!$B$4,Data!$H$11,J45=Data!$B$5,Data!$H$5,J45=Data!$B$6,Data!$H$21,J45=Data!$B$7,Data!$H$6,J45=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I45=\"\",\"\",IF(I45='ARRS Summary'!B$30,L45/2,K45)/12*N45)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I46=\"\",\"\",IF(I46='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I46,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I46<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J46=Data!$B$4,Data!$H$11,J46=Data!$B$5,Data!$H$5,J46=Data!$B$6,Data!$H$21,J46=Data!$B$7,Data!$H$6,J46=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I46=\"\",\"\",IF(I46='ARRS Summary'!B$30,L46/2,K46)/12*N46)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I47=\"\",\"\",IF(I47='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I47,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I47<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J47=Data!$B$4,Data!$H$11,J47=Data!$B$5,Data!$H$5,J47=Data!$B$6,Data!$H$21,J47=Data!$B$7,Data!$H$6,J47=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I47=\"\",\"\",IF(I47='ARRS Summary'!B$30,L47/2,K47)/12*N47)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I48=\"\",\"\",IF(I48='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I48,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I48<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J48=Data!$B$4,Data!$H$11,J48=Data!$B$5,Data!$H$5,J48=Data!$B$6,Data!$H$21,J48=Data!$B$7,Data!$H$6,J48=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I48=\"\",\"\",IF(I48='ARRS Summary'!B$30,L48/2,K48)/12*N48)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I49=\"\",\"\",IF(I49='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I49,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I49<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J49=Data!$B$4,Data!$H$11,J49=Data!$B$5,Data!$H$5,J49=Data!$B$6,Data!$H$21,J49=Data!$B$7,Data!$H$6,J49=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I49=\"\",\"\",IF(I49='ARRS Summary'!B$30,L49/2,K49)/12*N49)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I50=\"\",\"\",IF(I50='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I50,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I50<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J50=Data!$B$4,Data!$H$11,J50=Data!$B$5,Data!$H$5,J50=Data!$B$6,Data!$H$21,J50=Data!$B$7,Data!$H$6,J50=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I50=\"\",\"\",IF(I50='ARRS Summary'!B$30,L50/2,K50)/12*N50)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I51=\"\",\"\",IF(I51='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I51,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I51<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J51=Data!$B$4,Data!$H$11,J51=Data!$B$5,Data!$H$5,J51=Data!$B$6,Data!$H$21,J51=Data!$B$7,Data!$H$6,J51=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I51=\"\",\"\",IF(I51='ARRS Summary'!B$30,L51/2,K51)/12*N51)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I52=\"\",\"\",IF(I52='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I52,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I52<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J52=Data!$B$4,Data!$H$11,J52=Data!$B$5,Data!$H$5,J52=Data!$B$6,Data!$H$21,J52=Data!$B$7,Data!$H$6,J52=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I52=\"\",\"\",IF(I52='ARRS Summary'!B$30,L52/2,K52)/12*N52)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I53=\"\",\"\",IF(I53='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I53,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I53<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J53=Data!$B$4,Data!$H$11,J53=Data!$B$5,Data!$H$5,J53=Data!$B$6,Data!$H$21,J53=Data!$B$7,Data!$H$6,J53=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I53=\"\",\"\",IF(I53='ARRS Summary'!B$30,L53/2,K53)/12*N53)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I54=\"\",\"\",IF(I54='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I54,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I54<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J54=Data!$B$4,Data!$H$11,J54=Data!$B$5,Data!$H$5,J54=Data!$B$6,Data!$H$21,J54=Data!$B$7,Data!$H$6,J54=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I54=\"\",\"\",IF(I54='ARRS Summary'!B$30,L54/2,K54)/12*N54)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I55=\"\",\"\",IF(I55='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I55,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I55<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J55=Data!$B$4,Data!$H$11,J55=Data!$B$5,Data!$H$5,J55=Data!$B$6,Data!$H$21,J55=Data!$B$7,Data!$H$6,J55=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I55=\"\",\"\",IF(I55='ARRS Summary'!B$30,L55/2,K55)/12*N55)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I56=\"\",\"\",IF(I56='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I56,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I56<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J56=Data!$B$4,Data!$H$11,J56=Data!$B$5,Data!$H$5,J56=Data!$B$6,Data!$H$21,J56=Data!$B$7,Data!$H$6,J56=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I56=\"\",\"\",IF(I56='ARRS Summary'!B$30,L56/2,K56)/12*N56)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I57=\"\",\"\",IF(I57='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I57,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I57<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J57=Data!$B$4,Data!$H$11,J57=Data!$B$5,Data!$H$5,J57=Data!$B$6,Data!$H$21,J57=Data!$B$7,Data!$H$6,J57=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I57=\"\",\"\",IF(I57='ARRS Summary'!B$30,L57/2,K57)/12*N57)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I58=\"\",\"\",IF(I58='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I58,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I58<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J58=Data!$B$4,Data!$H$11,J58=Data!$B$5,Data!$H$5,J58=Data!$B$6,Data!$H$21,J58=Data!$B$7,Data!$H$6,J58=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I58=\"\",\"\",IF(I58='ARRS Summary'!B$30,L58/2,K58)/12*N58)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I59=\"\",\"\",IF(I59='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I59,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I59<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J59=Data!$B$4,Data!$H$11,J59=Data!$B$5,Data!$H$5,J59=Data!$B$6,Data!$H$21,J59=Data!$B$7,Data!$H$6,J59=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I59=\"\",\"\",IF(I59='ARRS Summary'!B$30,L59/2,K59)/12*N59)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I60=\"\",\"\",IF(I60='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I60,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I60<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J60=Data!$B$4,Data!$H$11,J60=Data!$B$5,Data!$H$5,J60=Data!$B$6,Data!$H$21,J60=Data!$B$7,Data!$H$6,J60=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I60=\"\",\"\",IF(I60='ARRS Summary'!B$30,L60/2,K60)/12*N60)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I61=\"\",\"\",IF(I61='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I61,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I61<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J61=Data!$B$4,Data!$H$11,J61=Data!$B$5,Data!$H$5,J61=Data!$B$6,Data!$H$21,J61=Data!$B$7,Data!$H$6,J61=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I61=\"\",\"\",IF(I61='ARRS Summary'!B$30,L61/2,K61)/12*N61)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I62=\"\",\"\",IF(I62='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I62,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I62<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J62=Data!$B$4,Data!$H$11,J62=Data!$B$5,Data!$H$5,J62=Data!$B$6,Data!$H$21,J62=Data!$B$7,Data!$H$6,J62=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I62=\"\",\"\",IF(I62='ARRS Summary'!B$30,L62/2,K62)/12*N62)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I63=\"\",\"\",IF(I63='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I63,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I63<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J63=Data!$B$4,Data!$H$11,J63=Data!$B$5,Data!$H$5,J63=Data!$B$6,Data!$H$21,J63=Data!$B$7,Data!$H$6,J63=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I63=\"\",\"\",IF(I63='ARRS Summary'!B$30,L63/2,K63)/12*N63)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I64=\"\",\"\",IF(I64='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I64,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I64<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J64=Data!$B$4,Data!$H$11,J64=Data!$B$5,Data!$H$5,J64=Data!$B$6,Data!$H$21,J64=Data!$B$7,Data!$H$6,J64=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I64=\"\",\"\",IF(I64='ARRS Summary'!B$30,L64/2,K64)/12*N64)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I65=\"\",\"\",IF(I65='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I65,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I65<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J65=Data!$B$4,Data!$H$11,J65=Data!$B$5,Data!$H$5,J65=Data!$B$6,Data!$H$21,J65=Data!$B$7,Data!$H$6,J65=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I65=\"\",\"\",IF(I65='ARRS Summary'!B$30,L65/2,K65)/12*N65)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I66=\"\",\"\",IF(I66='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I66,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I66<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J66=Data!$B$4,Data!$H$11,J66=Data!$B$5,Data!$H$5,J66=Data!$B$6,Data!$H$21,J66=Data!$B$7,Data!$H$6,J66=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I66=\"\",\"\",IF(I66='ARRS Summary'!B$30,L66/2,K66)/12*N66)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I67=\"\",\"\",IF(I67='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I67,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I67<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J67=Data!$B$4,Data!$H$11,J67=Data!$B$5,Data!$H$5,J67=Data!$B$6,Data!$H$21,J67=Data!$B$7,Data!$H$6,J67=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I67=\"\",\"\",IF(I67='ARRS Summary'!B$30,L67/2,K67)/12*N67)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I68=\"\",\"\",IF(I68='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I68,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I68<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J68=Data!$B$4,Data!$H$11,J68=Data!$B$5,Data!$H$5,J68=Data!$B$6,Data!$H$21,J68=Data!$B$7,Data!$H$6,J68=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I68=\"\",\"\",IF(I68='ARRS Summary'!B$30,L68/2,K68)/12*N68)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I69=\"\",\"\",IF(I69='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I69,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I69<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J69=Data!$B$4,Data!$H$11,J69=Data!$B$5,Data!$H$5,J69=Data!$B$6,Data!$H$21,J69=Data!$B$7,Data!$H$6,J69=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I69=\"\",\"\",IF(I69='ARRS Summary'!B$30,L69/2,K69)/12*N69)","v":""},null,{"$f":"IF(R69=\"\",\"\",IF(R69<V69,0,R69-V69))","v":""},null,"","",null,{"$f":"IF(W69=\"\",\"\",IF(W69<AA69,0,W69-AA69))","v":""},null,"","",null,"",null,"","",null,{"$f":"IF(AG69=\"\",\"\",IF(AG69<AK69,0,AG69-AK69))","v":""},null,"","",null,{"$f":"IF(AL69=\"\",\"\",IF(AL69<AP69,0,AL69-AP69))","v":""},null,"","",null,{"$f":"IF(AQ69=\"\",\"\",IF(AQ69<AU69,0,AQ69-AU69))","v":""},null,{"$f":"IF(AQ69=\"\",\"\",MIN(AQ69,$Q69))","v":""},{"$f":"IF(AQ69=\"\",\"\",\"Please enter to match portal\")","v":""},null,{"$f":"IF(AV69=\"\",\"\",IF(AV69<AZ69,0,AV69-AZ69))","v":""},null,"","",null,{"$f":"IF(BA69=\"\",\"\",IF(BA69<BE69,0,BA69-BE69))","v":""},null,"","",null,{"$f":"IF(BF69=\"\",\"\",IF(BF69<BJ69,0,BF69-BJ69))","v":""},null,"","",null,{"$f":"IF(BK69=\"\",\"\",IF(BK69<BO69,0,BK69-BO69))","v":""},null,"","",null,{"$f":"IF(BP69=\"\",\"\",IF(BP69<BT69,0,BP69-BT69))","v":""},null,"","",null,{"$f":"IF(BU69=\"\",\"\",IF(BU69<BY69,0,BU69-BY69))","v":""},null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I70=\"\",\"\",IF(I70='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I70,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I70<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J70=Data!$B$4,Data!$H$11,J70=Data!$B$5,Data!$H$5,J70=Data!$B$6,Data!$H$21,J70=Data!$B$7,Data!$H$6,J70=Data!$B$8,Data!$H$19))","v":""},null,{"$f":"IF(M70=\"\",\"\",M70/37.5)","v":""},null,null,{"$f":"IF(I70=\"\",\"\",IF(I70='ARRS Summary'!B$30,L70/2,K70)/12*N70)","v":""},null,"",null,{"$f":"IF(R70=\"\",\"\",MIN(R70,$Q70))","v":""},{"$f":"IF(R70=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(W70=\"\",\"\",MIN(W70,$Q70))","v":""},{"$f":"IF(W70=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(AB70=\"\",\"\",MIN(AB70,$Q70))","v":""},{"$f":"IF(AB70=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(AG70=\"\",\"\",MIN(AG70,$Q70))","v":""},{"$f":"IF(AG70=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(AL70=\"\",\"\",MIN(AL70,$Q70))","v":""},{"$f":"IF(AL70=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,"","",null,"",null,{"$f":"IF(AV70=\"\",\"\",MIN(AV70,$Q70))","v":""},{"$f":"IF(AV70=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(BA70=\"\",\"\",MIN(BA70,$Q70))","v":""},{"$f":"IF(BA70=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(BF70=\"\",\"\",MIN(BF70,$Q70))","v":""},{"$f":"IF(BF70=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(BK70=\"\",\"\",MIN(BK70,$Q70))","v":""},{"$f":"IF(BK70=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(BP70=\"\",\"\",MIN(BP70,$Q70))","v":""},{"$f":"IF(BP70=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,{"$f":"IF(BU70=\"\",\"\",MIN(BU70,$Q70))","v":""},{"$f":"IF(BU70=\"\",\"\",\"Please enter to match portal\")","v":""},{"$f":"IF(I70=\"\",\"\",SUM(V70,AA70,AF70,AK70,AP70,AU70,AZ70,BE70,BJ70,BO70,BT70,BY70))","v":""},{"$f":"IF(I70=\"\",\"\",SUM(S70,X70,AC70,AH70,AM70,AR70,AW70,BB70,BG70,BL70,BQ70,BV70))","v":""},{"$f":"IF(I70=\"\",\"\",SUM(T70,Y70,AD70,AI70,AN70,AS70,AX70,BC70,BH70,BM70,BR70,BW70))","v":""},""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I71=\"\",\"\",IF(I71='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I71,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I71<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J71=Data!$B$4,Data!$H$11,J71=Data!$B$5,Data!$H$5,J71=Data!$B$6,Data!$H$21,J71=Data!$B$7,Data!$H$6,J71=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I71=\"\",\"\",IF(I71='ARRS Summary'!B$30,L71/2,K71)/12*N71)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I72=\"\",\"\",IF(I72='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I72,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I72<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J72=Data!$B$4,Data!$H$11,J72=Data!$B$5,Data!$H$5,J72=Data!$B$6,Data!$H$21,J72=Data!$B$7,Data!$H$6,J72=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I72=\"\",\"\",IF(I72='ARRS Summary'!B$30,L72/2,K72)/12*N72)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I73=\"\",\"\",IF(I73='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I73,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I73<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J73=Data!$B$4,Data!$H$11,J73=Data!$B$5,Data!$H$5,J73=Data!$B$6,Data!$H$21,J73=Data!$B$7,Data!$H$6,J73=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I73=\"\",\"\",IF(I73='ARRS Summary'!B$30,L73/2,K73)/12*N73)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I74=\"\",\"\",IF(I74='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I74,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I74<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J74=Data!$B$4,Data!$H$11,J74=Data!$B$5,Data!$H$5,J74=Data!$B$6,Data!$H$21,J74=Data!$B$7,Data!$H$6,J74=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I74=\"\",\"\",IF(I74='ARRS Summary'!B$30,L74/2,K74)/12*N74)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I75=\"\",\"\",IF(I75='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I75,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I75<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J75=Data!$B$4,Data!$H$11,J75=Data!$B$5,Data!$H$5,J75=Data!$B$6,Data!$H$21,J75=Data!$B$7,Data!$H$6,J75=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I75=\"\",\"\",IF(I75='ARRS Summary'!B$30,L75/2,K75)/12*N75)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I76=\"\",\"\",IF(I76='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I76,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I76<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J76=Data!$B$4,Data!$H$11,J76=Data!$B$5,Data!$H$5,J76=Data!$B$6,Data!$H$21,J76=Data!$B$7,Data!$H$6,J76=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I76=\"\",\"\",IF(I76='ARRS Summary'!B$30,L76/2,K76)/12*N76)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I77=\"\",\"\",IF(I77='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I77,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I77<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J77=Data!$B$4,Data!$H$11,J77=Data!$B$5,Data!$H$5,J77=Data!$B$6,Data!$H$21,J77=Data!$B$7,Data!$H$6,J77=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I77=\"\",\"\",IF(I77='ARRS Summary'!B$30,L77/2,K77)/12*N77)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I78=\"\",\"\",IF(I78='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I78,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I78<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J78=Data!$B$4,Data!$H$11,J78=Data!$B$5,Data!$H$5,J78=Data!$B$6,Data!$H$21,J78=Data!$B$7,Data!$H$6,J78=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I78=\"\",\"\",IF(I78='ARRS Summary'!B$30,L78/2,K78)/12*N78)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I79=\"\",\"\",IF(I79='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I79,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I79<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J79=Data!$B$4,Data!$H$11,J79=Data!$B$5,Data!$H$5,J79=Data!$B$6,Data!$H$21,J79=Data!$B$7,Data!$H$6,J79=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I79=\"\",\"\",IF(I79='ARRS Summary'!B$30,L79/2,K79)/12*N79)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I80=\"\",\"\",IF(I80='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I80,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I80<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J80=Data!$B$4,Data!$H$11,J80=Data!$B$5,Data!$H$5,J80=Data!$B$6,Data!$H$21,J80=Data!$B$7,Data!$H$6,J80=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I80=\"\",\"\",IF(I80='ARRS Summary'!B$30,L80/2,K80)/12*N80)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I81=\"\",\"\",IF(I81='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I81,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I81<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J81=Data!$B$4,Data!$H$11,J81=Data!$B$5,Data!$H$5,J81=Data!$B$6,Data!$H$21,J81=Data!$B$7,Data!$H$6,J81=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I81=\"\",\"\",IF(I81='ARRS Summary'!B$30,L81/2,K81)/12*N81)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I82=\"\",\"\",IF(I82='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I82,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I82<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J82=Data!$B$4,Data!$H$11,J82=Data!$B$5,Data!$H$5,J82=Data!$B$6,Data!$H$21,J82=Data!$B$7,Data!$H$6,J82=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I82=\"\",\"\",IF(I82='ARRS Summary'!B$30,L82/2,K82)/12*N82)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I83=\"\",\"\",IF(I83='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I83,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I83<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J83=Data!$B$4,Data!$H$11,J83=Data!$B$5,Data!$H$5,J83=Data!$B$6,Data!$H$21,J83=Data!$B$7,Data!$H$6,J83=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I83=\"\",\"\",IF(I83='ARRS Summary'!B$30,L83/2,K83)/12*N83)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I84=\"\",\"\",IF(I84='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I84,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I84<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J84=Data!$B$4,Data!$H$11,J84=Data!$B$5,Data!$H$5,J84=Data!$B$6,Data!$H$21,J84=Data!$B$7,Data!$H$6,J84=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I84=\"\",\"\",IF(I84='ARRS Summary'!B$30,L84/2,K84)/12*N84)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",{"$f":"IF(I84=\"\",\"\",SUM(CA84,CB84))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I85=\"\",\"\",IF(I85='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I85,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I85<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J85=Data!$B$4,Data!$H$11,J85=Data!$B$5,Data!$H$5,J85=Data!$B$6,Data!$H$21,J85=Data!$B$7,Data!$H$6,J85=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I85=\"\",\"\",IF(I85='ARRS Summary'!B$30,L85/2,K85)/12*N85)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I86=\"\",\"\",IF(I86='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I86,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I86<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J86=Data!$B$4,Data!$H$11,J86=Data!$B$5,Data!$H$5,J86=Data!$B$6,Data!$H$21,J86=Data!$B$7,Data!$H$6,J86=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I86=\"\",\"\",IF(I86='ARRS Summary'!B$30,L86/2,K86)/12*N86)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I87=\"\",\"\",IF(I87='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I87,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I87<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J87=Data!$B$4,Data!$H$11,J87=Data!$B$5,Data!$H$5,J87=Data!$B$6,Data!$H$21,J87=Data!$B$7,Data!$H$6,J87=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I87=\"\",\"\",IF(I87='ARRS Summary'!B$30,L87/2,K87)/12*N87)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I88=\"\",\"\",IF(I88='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I88,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I88<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J88=Data!$B$4,Data!$H$11,J88=Data!$B$5,Data!$H$5,J88=Data!$B$6,Data!$H$21,J88=Data!$B$7,Data!$H$6,J88=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I88=\"\",\"\",IF(I88='ARRS Summary'!B$30,L88/2,K88)/12*N88)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I89=\"\",\"\",IF(I89='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I89,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I89<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J89=Data!$B$4,Data!$H$11,J89=Data!$B$5,Data!$H$5,J89=Data!$B$6,Data!$H$21,J89=Data!$B$7,Data!$H$6,J89=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I89=\"\",\"\",IF(I89='ARRS Summary'!B$30,L89/2,K89)/12*N89)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I90=\"\",\"\",IF(I90='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I90,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I90<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J90=Data!$B$4,Data!$H$11,J90=Data!$B$5,Data!$H$5,J90=Data!$B$6,Data!$H$21,J90=Data!$B$7,Data!$H$6,J90=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I90=\"\",\"\",IF(I90='ARRS Summary'!B$30,L90/2,K90)/12*N90)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I91=\"\",\"\",IF(I91='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I91,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I91<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J91=Data!$B$4,Data!$H$11,J91=Data!$B$5,Data!$H$5,J91=Data!$B$6,Data!$H$21,J91=Data!$B$7,Data!$H$6,J91=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I91=\"\",\"\",IF(I91='ARRS Summary'!B$30,L91/2,K91)/12*N91)","v":""},null,"",null,"","",null,"",null,"","",null,{"$f":"IF(AB91=\"\",\"\",IF(AB91<$Q91,0,AB91-AF91))","v":""},null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I92=\"\",\"\",IF(I92='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I92,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I92<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J92=Data!$B$4,Data!$H$11,J92=Data!$B$5,Data!$H$5,J92=Data!$B$6,Data!$H$21,J92=Data!$B$7,Data!$H$6,J92=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I92=\"\",\"\",IF(I92='ARRS Summary'!B$30,L92/2,K92)/12*N92)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I93=\"\",\"\",IF(I93='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I93,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I93<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J93=Data!$B$4,Data!$H$11,J93=Data!$B$5,Data!$H$5,J93=Data!$B$6,Data!$H$21,J93=Data!$B$7,Data!$H$6,J93=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I93=\"\",\"\",IF(I93='ARRS Summary'!B$30,L93/2,K93)/12*N93)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I94=\"\",\"\",IF(I94='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I94,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I94<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J94=Data!$B$4,Data!$H$11,J94=Data!$B$5,Data!$H$5,J94=Data!$B$6,Data!$H$21,J94=Data!$B$7,Data!$H$6,J94=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I94=\"\",\"\",IF(I94='ARRS Summary'!B$30,L94/2,K94)/12*N94)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I95=\"\",\"\",IF(I95='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I95,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I95<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J95=Data!$B$4,Data!$H$11,J95=Data!$B$5,Data!$H$5,J95=Data!$B$6,Data!$H$21,J95=Data!$B$7,Data!$H$6,J95=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I95=\"\",\"\",IF(I95='ARRS Summary'!B$30,L95/2,K95)/12*N95)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I96=\"\",\"\",IF(I96='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I96,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I96<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J96=Data!$B$4,Data!$H$11,J96=Data!$B$5,Data!$H$5,J96=Data!$B$6,Data!$H$21,J96=Data!$B$7,Data!$H$6,J96=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I96=\"\",\"\",IF(I96='ARRS Summary'!B$30,L96/2,K96)/12*N96)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I97=\"\",\"\",IF(I97='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I97,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I97<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J97=Data!$B$4,Data!$H$11,J97=Data!$B$5,Data!$H$5,J97=Data!$B$6,Data!$H$21,J97=Data!$B$7,Data!$H$6,J97=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I97=\"\",\"\",IF(I97='ARRS Summary'!B$30,L97/2,K97)/12*N97)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I98=\"\",\"\",IF(I98='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I98,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I98<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J98=Data!$B$4,Data!$H$11,J98=Data!$B$5,Data!$H$5,J98=Data!$B$6,Data!$H$21,J98=Data!$B$7,Data!$H$6,J98=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I98=\"\",\"\",IF(I98='ARRS Summary'!B$30,L98/2,K98)/12*N98)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I99=\"\",\"\",IF(I99='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I99,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I99<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J99=Data!$B$4,Data!$H$11,J99=Data!$B$5,Data!$H$5,J99=Data!$B$6,Data!$H$21,J99=Data!$B$7,Data!$H$6,J99=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I99=\"\",\"\",IF(I99='ARRS Summary'!B$30,L99/2,K99)/12*N99)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I100=\"\",\"\",IF(I100='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I100,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I100<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J100=Data!$B$4,Data!$H$11,J100=Data!$B$5,Data!$H$5,J100=Data!$B$6,Data!$H$21,J100=Data!$B$7,Data!$H$6,J100=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I100=\"\",\"\",IF(I100='ARRS Summary'!B$30,L100/2,K100)/12*N100)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I101=\"\",\"\",IF(I101='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I101,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I101<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J101=Data!$B$4,Data!$H$11,J101=Data!$B$5,Data!$H$5,J101=Data!$B$6,Data!$H$21,J101=Data!$B$7,Data!$H$6,J101=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I101=\"\",\"\",IF(I101='ARRS Summary'!B$30,L101/2,K101)/12*N101)","v":""},null,{"$f":"IF(R101=\"\",\"\",IF(R101<V101,0,R101-V101))","v":""},null,"","",null,{"$f":"IF(W101=\"\",\"\",IF(W101<AA101,0,W101-AA101))","v":""},null,"","",null,{"$f":"IF(AB101=\"\",\"\",IF(AB101<$Q101,0,AB101-AF101))","v":""},null,"","",null,{"$f":"IF(AG101=\"\",\"\",IF(AG101<AK101,0,AG101-AK101))","v":""},null,"","",null,{"$f":"IF(AL101=\"\",\"\",IF(AL101<AP101,0,AL101-AP101))","v":""},null,"","",null,{"$f":"IF(AQ101=\"\",\"\",IF(AQ101<AU101,0,AQ101-AU101))","v":""},null,"","",null,{"$f":"IF(AV101=\"\",\"\",IF(AV101<AZ101,0,AV101-AZ101))","v":""},null,"","",null,{"$f":"IF(BA101=\"\",\"\",IF(BA101<BE101,0,BA101-BE101))","v":""},null,"","",null,{"$f":"IF(BF101=\"\",\"\",IF(BF101<BJ101,0,BF101-BJ101))","v":""},null,"","",null,{"$f":"IF(BK101=\"\",\"\",IF(BK101<BO101,0,BK101-BO101))","v":""},null,"","",null,{"$f":"IF(BP101=\"\",\"\",IF(BP101<BT101,0,BP101-BT101))","v":""},null,"","",null,{"$f":"IF(BU101=\"\",\"\",IF(BU101<BY101,0,BU101-BY101))","v":""},null,"","","",{"$f":"IF(I101=\"\",\"\",SUM(S101,X101,AC101,AH101,AM101,AR101,AW101,BB101,BG101,BL101,BQ101,BV101))","v":""},{"$f":"IF(I101=\"\",\"\",SUM(T101,Y101,AD101,AI101,AN101,AS101,AX101,BC101,BH101,BM101,BR101,BW101))","v":""},{"$f":"IF(I101=\"\",\"\",SUM(CA101,CB101))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I102=\"\",\"\",IF(I102='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I102,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I102<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J102=Data!$B$4,Data!$H$11,J102=Data!$B$5,Data!$H$5,J102=Data!$B$6,Data!$H$21,J102=Data!$B$7,Data!$H$6,J102=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I102=\"\",\"\",IF(I102='ARRS Summary'!B$30,L102/2,K102)/12*N102)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I103=\"\",\"\",IF(I103='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I103,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I103<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J103=Data!$B$4,Data!$H$11,J103=Data!$B$5,Data!$H$5,J103=Data!$B$6,Data!$H$21,J103=Data!$B$7,Data!$H$6,J103=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I103=\"\",\"\",IF(I103='ARRS Summary'!B$30,L103/2,K103)/12*N103)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I104=\"\",\"\",IF(I104='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I104,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I104<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J104=Data!$B$4,Data!$H$11,J104=Data!$B$5,Data!$H$5,J104=Data!$B$6,Data!$H$21,J104=Data!$B$7,Data!$H$6,J104=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I104=\"\",\"\",IF(I104='ARRS Summary'!B$30,L104/2,K104)/12*N104)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I105=\"\",\"\",IF(I105='ARRS Summary'!$B$30,\"Enter A4C band here\",\"No Entry Required\"))","v":""},{"$f":"VLOOKUP(I105,Data!F$4:H$21,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I105<>'ARRS Summary'!B$30,\"\",_xlfn.IFS(J105=Data!$B$4,Data!$H$11,J105=Data!$B$5,Data!$H$5,J105=Data!$B$6,Data!$H$21,J105=Data!$B$7,Data!$H$6,J105=Data!$B$8,Data!$H$19))","v":""},null,"",null,null,{"$f":"IF(I105=\"\",\"\",IF(I105='ARRS Summary'!B$30,L105/2,K105)/12*N105)","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,{"$f":"IF(AQ105=\"\",\"\",MIN(AQ105,$Q105))","v":""},{"$f":"IF(AQ105=\"\",\"\",\"Please enter to match portal\")","v":""},null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","",null,"",null,"","","","","",""]

{"sheet":"PCN NonARRS","index":3,"n_rows":106,"n_cols":50,"rows_kept":106,"cut":false,"hidden":true,"merged":[[2,37,2,39],[2,40,2,42],[2,43,2,45],[2,46,2,48],[2,49,3,49],[0,1,0,5],[2,19,2,21],[2,22,2,24],[2,25,2,27],[2,28,2,30],[2,31,2,33],[2,34,2,36],[1,6,2,6],[1,10,2,10],[1,12,2,12],[2,13,2,15],[2,16,2,18]]}
[null,"Non-ARR Staff (optional)",null,null,null,null,null,null,null,null,null,null,"TOTALS",{"$f":"SUM(N4:N106)","v":0},{"$f":"SUM(O4:O106)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Calculated",null,"Enter when left",null,null,"Calculated",null,null,"Calculated",null,null,"Calculated",null,null,"Calculated",null,null,"Calculated",null,null,"Calculated",null,null,"Calculated",null,null,"Calculated",null,null,"Calculated",null,null,"Calculated",null,null,"Calculated",null,null,"Calculated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"April",null,null,"May",null,null,"June",null,null,"July",null,null,"August",null,null,"September",null,null,"October",null,null,"November",null,null,"December",null,null,"January",null,null,"February",null,null,"March",null,null,"Annual Total"]
[null,"Name","Employer","Role","Appraisal Date 23/24","Line Manager / Supervisor","Funding Stream","Non MH salary","MH salary","Hours/week","WTE","PCN Start Date","PCN End Date","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month","Total Salary Costs","Other Costs","Total Month"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J5=\"\",\"\",J5/37.5)","v":""},null,null,null,null,{"$f":"IF(N5=\"\",\"\",SUM(N5:O5))","v":""},null,null,{"$f":"IF(Q5=\"\",\"\",SUM(Q5:R5))","v":""},null,null,{"$f":"IF(T5=\"\",\"\",SUM(T5:U5))","v":""},null,null,{"$f":"IF(W5=\"\",\"\",SUM(W5:X5))","v":""},null,null,{"$f":"IF(Z5=\"\",\"\",SUM(Z5:AA5))","v":""},null,null,{"$f":"IF(AC5=\"\",\"\",SUM(AC5:AD5))","v":""},null,null,{"$f":"IF(AF5=\"\",\"\",SUM(AF5:AG5))","v":""},null,null,{"$f":"IF(AI5=\"\",\"\",SUM(AI5:AJ5))","v":""},null,null,{"$f":"IF(AL5=\"\",\"\",SUM(AL5:AM5))","v":""},null,null,{"$f":"IF(AO5=\"\",\"\",SUM(AO5:AP5))","v":""},null,null,{"$f":"IF(AR5=\"\",\"\",SUM(AR5:AS5))","v":""},null,null,{"$f":"IF(AU5=\"\",\"\",SUM(AU5:AV5))","v":""},{"$f":"IF(AW5=\"\",\"\",SUM(AW5,AT5,AQ5,AN5,AK5,AH5,AE5,AB5,Y5,V5,S5,P5))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(AW6=\"\",\"\",SUM(AW6,AT6,AQ6,AN6,AK6,AH6,AE6,AB6,Y6,V6,S6,P6))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D19,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D19<>'ARRS Summary'!B$30,\"\",IF(D19='ARRS Summary'!B$30,IF(G19=Data!B$5,Data!#REF!,IF(G19=Data!B$6,Data!#REF!,IF(G19=Data!B$7,Data!#REF!,IF(G19=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D20,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D20<>'ARRS Summary'!B$30,\"\",IF(D20='ARRS Summary'!B$30,IF(G20=Data!B$5,Data!#REF!,IF(G20=Data!B$6,Data!#REF!,IF(G20=Data!B$7,Data!#REF!,IF(G20=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D21,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D21<>'ARRS Summary'!B$30,\"\",IF(D21='ARRS Summary'!B$30,IF(G21=Data!B$5,Data!#REF!,IF(G21=Data!B$6,Data!#REF!,IF(G21=Data!B$7,Data!#REF!,IF(G21=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D22,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D22<>'ARRS Summary'!B$30,\"\",IF(D22='ARRS Summary'!B$30,IF(G22=Data!B$5,Data!#REF!,IF(G22=Data!B$6,Data!#REF!,IF(G22=Data!B$7,Data!#REF!,IF(G22=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D23,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D23<>'ARRS Summary'!B$30,\"\",IF(D23='ARRS Summary'!B$30,IF(G23=Data!B$5,Data!#REF!,IF(G23=Data!B$6,Data!#REF!,IF(G23=Data!B$7,Data!#REF!,IF(G23=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D24,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D24<>'ARRS Summary'!B$30,\"\",IF(D24='ARRS Summary'!B$30,IF(G24=Data!B$5,Data!#REF!,IF(G24=Data!B$6,Data!#REF!,IF(G24=Data!B$7,Data!#REF!,IF(G24=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D25,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D25<>'ARRS Summary'!B$30,\"\",IF(D25='ARRS Summary'!B$30,IF(G25=Data!B$5,Data!#REF!,IF(G25=Data!B$6,Data!#REF!,IF(G25=Data!B$7,Data!#REF!,IF(G25=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D26,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D26<>'ARRS Summary'!B$30,\"\",IF(D26='ARRS Summary'!B$30,IF(G26=Data!B$5,Data!#REF!,IF(G26=Data!B$6,Data!#REF!,IF(G26=Data!B$7,Data!#REF!,IF(G26=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D27,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D27<>'ARRS Summary'!B$30,\"\",IF(D27='ARRS Summary'!B$30,IF(G27=Data!B$5,Data!#REF!,IF(G27=Data!B$6,Data!#REF!,IF(G27=Data!B$7,Data!#REF!,IF(G27=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D28,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D28<>'ARRS Summary'!B$30,\"\",IF(D28='ARRS Summary'!B$30,IF(G28=Data!B$5,Data!#REF!,IF(G28=Data!B$6,Data!#REF!,IF(G28=Data!B$7,Data!#REF!,IF(G28=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D29,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D29<>'ARRS Summary'!B$30,\"\",IF(D29='ARRS Summary'!B$30,IF(G29=Data!B$5,Data!#REF!,IF(G29=Data!B$6,Data!#REF!,IF(G29=Data!B$7,Data!#REF!,IF(G29=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D30,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D30<>'ARRS Summary'!B$30,\"\",IF(D30='ARRS Summary'!B$30,IF(G30=Data!B$5,Data!#REF!,IF(G30=Data!B$6,Data!#REF!,IF(G30=Data!B$7,Data!#REF!,IF(G30=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D31,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D31<>'ARRS Summary'!B$30,\"\",IF(D31='ARRS Summary'!B$30,IF(G31=Data!B$5,Data!#REF!,IF(G31=Data!B$6,Data!#REF!,IF(G31=Data!B$7,Data!#REF!,IF(G31=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D32,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D32<>'ARRS Summary'!B$30,\"\",IF(D32='ARRS Summary'!B$30,IF(G32=Data!B$5,Data!#REF!,IF(G32=Data!B$6,Data!#REF!,IF(G32=Data!B$7,Data!#REF!,IF(G32=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D33,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D33<>'ARRS Summary'!B$30,\"\",IF(D33='ARRS Summary'!B$30,IF(G33=Data!B$5,Data!#REF!,IF(G33=Data!B$6,Data!#REF!,IF(G33=Data!B$7,Data!#REF!,IF(G33=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D34,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D34<>'ARRS Summary'!B$30,\"\",IF(D34='ARRS Summary'!B$30,IF(G34=Data!B$5,Data!#REF!,IF(G34=Data!B$6,Data!#REF!,IF(G34=Data!B$7,Data!#REF!,IF(G34=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D35,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D35<>'ARRS Summary'!B$30,\"\",IF(D35='ARRS Summary'!B$30,IF(G35=Data!B$5,Data!#REF!,IF(G35=Data!B$6,Data!#REF!,IF(G35=Data!B$7,Data!#REF!,IF(G35=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D36,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D36<>'ARRS Summary'!B$30,\"\",IF(D36='ARRS Summary'!B$30,IF(G36=Data!B$5,Data!#REF!,IF(G36=Data!B$6,Data!#REF!,IF(G36=Data!B$7,Data!#REF!,IF(G36=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D37,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D37<>'ARRS Summary'!B$30,\"\",IF(D37='ARRS Summary'!B$30,IF(G37=Data!B$5,Data!#REF!,IF(G37=Data!B$6,Data!#REF!,IF(G37=Data!B$7,Data!#REF!,IF(G37=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,{"$f":"IF(J37=\"\",\"\",J37/37.5)","v":""},null,null,null,null,{"$f":"IF(N37=\"\",\"\",SUM(N37:O37))","v":""},null,null,{"$f":"IF(Q37=\"\",\"\",SUM(Q37:R37))","v":""},null,null,{"$f":"IF(T37=\"\",\"\",SUM(T37:U37))","v":""},null,null,{"$f":"IF(W37=\"\",\"\",SUM(W37:X37))","v":""},null,null,{"$f":"IF(Z37=\"\",\"\",SUM(Z37:AA37))","v":""},null,null,{"$f":"IF(AC37=\"\",\"\",SUM(AC37:AD37))","v":""},null,null,{"$f":"IF(AF37=\"\",\"\",SUM(AF37:AG37))","v":""},null,null,{"$f":"IF(AI37=\"\",\"\",SUM(AI37:AJ37))","v":""},null,null,{"$f":"IF(AL37=\"\",\"\",SUM(AL37:AM37))","v":""},null,null,{"$f":"IF(AO37=\"\",\"\",SUM(AO37:AP37))","v":""},null,null,{"$f":"IF(AR37=\"\",\"\",SUM(AR37:AS37))","v":""},null,null,{"$f":"IF(AU37=\"\",\"\",SUM(AU37:AV37))","v":""},""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D38,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D38<>'ARRS Summary'!B$30,\"\",IF(D38='ARRS Summary'!B$30,IF(G38=Data!B$5,Data!#REF!,IF(G38=Data!B$6,Data!#REF!,IF(G38=Data!B$7,Data!#REF!,IF(G38=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D39,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D39<>'ARRS Summary'!B$30,\"\",IF(D39='ARRS Summary'!B$30,IF(G39=Data!B$5,Data!#REF!,IF(G39=Data!B$6,Data!#REF!,IF(G39=Data!B$7,Data!#REF!,IF(G39=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D40,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D40<>'ARRS Summary'!B$30,\"\",IF(D40='ARRS Summary'!B$30,IF(G40=Data!B$5,Data!#REF!,IF(G40=Data!B$6,Data!#REF!,IF(G40=Data!B$7,Data!#REF!,IF(G40=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D41,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D41<>'ARRS Summary'!B$30,\"\",IF(D41='ARRS Summary'!B$30,IF(G41=Data!B$5,Data!#REF!,IF(G41=Data!B$6,Data!#REF!,IF(G41=Data!B$7,Data!#REF!,IF(G41=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D42,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D42<>'ARRS Summary'!B$30,\"\",IF(D42='ARRS Summary'!B$30,IF(G42=Data!B$5,Data!#REF!,IF(G42=Data!B$6,Data!#REF!,IF(G42=Data!B$7,Data!#REF!,IF(G42=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D43,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D43<>'ARRS Summary'!B$30,\"\",IF(D43='ARRS Summary'!B$30,IF(G43=Data!B$5,Data!#REF!,IF(G43=Data!B$6,Data!#REF!,IF(G43=Data!B$7,Data!#REF!,IF(G43=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D44,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D44<>'ARRS Summary'!B$30,\"\",IF(D44='ARRS Summary'!B$30,IF(G44=Data!B$5,Data!#REF!,IF(G44=Data!B$6,Data!#REF!,IF(G44=Data!B$7,Data!#REF!,IF(G44=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D45,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D45<>'ARRS Summary'!B$30,\"\",IF(D45='ARRS Summary'!B$30,IF(G45=Data!B$5,Data!#REF!,IF(G45=Data!B$6,Data!#REF!,IF(G45=Data!B$7,Data!#REF!,IF(G45=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D46,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D46<>'ARRS Summary'!B$30,\"\",IF(D46='ARRS Summary'!B$30,IF(G46=Data!B$5,Data!#REF!,IF(G46=Data!B$6,Data!#REF!,IF(G46=Data!B$7,Data!#REF!,IF(G46=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D47,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D47<>'ARRS Summary'!B$30,\"\",IF(D47='ARRS Summary'!B$30,IF(G47=Data!B$5,Data!#REF!,IF(G47=Data!B$6,Data!#REF!,IF(G47=Data!B$7,Data!#REF!,IF(G47=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D48,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D48<>'ARRS Summary'!B$30,\"\",IF(D48='ARRS Summary'!B$30,IF(G48=Data!B$5,Data!#REF!,IF(G48=Data!B$6,Data!#REF!,IF(G48=Data!B$7,Data!#REF!,IF(G48=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D49,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D49<>'ARRS Summary'!B$30,\"\",IF(D49='ARRS Summary'!B$30,IF(G49=Data!B$5,Data!#REF!,IF(G49=Data!B$6,Data!#REF!,IF(G49=Data!B$7,Data!#REF!,IF(G49=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D50,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D50<>'ARRS Summary'!B$30,\"\",IF(D50='ARRS Summary'!B$30,IF(G50=Data!B$5,Data!#REF!,IF(G50=Data!B$6,Data!#REF!,IF(G50=Data!B$7,Data!#REF!,IF(G50=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D51,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D51<>'ARRS Summary'!B$30,\"\",IF(D51='ARRS Summary'!B$30,IF(G51=Data!B$5,Data!#REF!,IF(G51=Data!B$6,Data!#REF!,IF(G51=Data!B$7,Data!#REF!,IF(G51=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D52,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D52<>'ARRS Summary'!B$30,\"\",IF(D52='ARRS Summary'!B$30,IF(G52=Data!B$5,Data!#REF!,IF(G52=Data!B$6,Data!#REF!,IF(G52=Data!B$7,Data!#REF!,IF(G52=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D53,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D53<>'ARRS Summary'!B$30,\"\",IF(D53='ARRS Summary'!B$30,IF(G53=Data!B$5,Data!#REF!,IF(G53=Data!B$6,Data!#REF!,IF(G53=Data!B$7,Data!#REF!,IF(G53=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D54,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D54<>'ARRS Summary'!B$30,\"\",IF(D54='ARRS Summary'!B$30,IF(G54=Data!B$5,Data!#REF!,IF(G54=Data!B$6,Data!#REF!,IF(G54=Data!B$7,Data!#REF!,IF(G54=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D55,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D55<>'ARRS Summary'!B$30,\"\",IF(D55='ARRS Summary'!B$30,IF(G55=Data!B$5,Data!#REF!,IF(G55=Data!B$6,Data!#REF!,IF(G55=Data!B$7,Data!#REF!,IF(G55=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D56,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D56<>'ARRS Summary'!B$30,\"\",IF(D56='ARRS Summary'!B$30,IF(G56=Data!B$5,Data!#REF!,IF(G56=Data!B$6,Data!#REF!,IF(G56=Data!B$7,Data!#REF!,IF(G56=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D57,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D57<>'ARRS Summary'!B$30,\"\",IF(D57='ARRS Summary'!B$30,IF(G57=Data!B$5,Data!#REF!,IF(G57=Data!B$6,Data!#REF!,IF(G57=Data!B$7,Data!#REF!,IF(G57=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D58,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D58<>'ARRS Summary'!B$30,\"\",IF(D58='ARRS Summary'!B$30,IF(G58=Data!B$5,Data!#REF!,IF(G58=Data!B$6,Data!#REF!,IF(G58=Data!B$7,Data!#REF!,IF(G58=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D59,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D59<>'ARRS Summary'!B$30,\"\",IF(D59='ARRS Summary'!B$30,IF(G59=Data!B$5,Data!#REF!,IF(G59=Data!B$6,Data!#REF!,IF(G59=Data!B$7,Data!#REF!,IF(G59=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D60,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D60<>'ARRS Summary'!B$30,\"\",IF(D60='ARRS Summary'!B$30,IF(G60=Data!B$5,Data!#REF!,IF(G60=Data!B$6,Data!#REF!,IF(G60=Data!B$7,Data!#REF!,IF(G60=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D61,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D61<>'ARRS Summary'!B$30,\"\",IF(D61='ARRS Summary'!B$30,IF(G61=Data!B$5,Data!#REF!,IF(G61=Data!B$6,Data!#REF!,IF(G61=Data!B$7,Data!#REF!,IF(G61=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D62,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D62<>'ARRS Summary'!B$30,\"\",IF(D62='ARRS Summary'!B$30,IF(G62=Data!B$5,Data!#REF!,IF(G62=Data!B$6,Data!#REF!,IF(G62=Data!B$7,Data!#REF!,IF(G62=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D63,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D63<>'ARRS Summary'!B$30,\"\",IF(D63='ARRS Summary'!B$30,IF(G63=Data!B$5,Data!#REF!,IF(G63=Data!B$6,Data!#REF!,IF(G63=Data!B$7,Data!#REF!,IF(G63=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D64,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D64<>'ARRS Summary'!B$30,\"\",IF(D64='ARRS Summary'!B$30,IF(G64=Data!B$5,Data!#REF!,IF(G64=Data!B$6,Data!#REF!,IF(G64=Data!B$7,Data!#REF!,IF(G64=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D65,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D65<>'ARRS Summary'!B$30,\"\",IF(D65='ARRS Summary'!B$30,IF(G65=Data!B$5,Data!#REF!,IF(G65=Data!B$6,Data!#REF!,IF(G65=Data!B$7,Data!#REF!,IF(G65=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D66,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D66<>'ARRS Summary'!B$30,\"\",IF(D66='ARRS Summary'!B$30,IF(G66=Data!B$5,Data!#REF!,IF(G66=Data!B$6,Data!#REF!,IF(G66=Data!B$7,Data!#REF!,IF(G66=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D67,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D67<>'ARRS Summary'!B$30,\"\",IF(D67='ARRS Summary'!B$30,IF(G67=Data!B$5,Data!#REF!,IF(G67=Data!B$6,Data!#REF!,IF(G67=Data!B$7,Data!#REF!,IF(G67=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D68,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D68<>'ARRS Summary'!B$30,\"\",IF(D68='ARRS Summary'!B$30,IF(G68=Data!B$5,Data!#REF!,IF(G68=Data!B$6,Data!#REF!,IF(G68=Data!B$7,Data!#REF!,IF(G68=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D69,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D69<>'ARRS Summary'!B$30,\"\",IF(D69='ARRS Summary'!B$30,IF(G69=Data!B$5,Data!#REF!,IF(G69=Data!B$6,Data!#REF!,IF(G69=Data!B$7,Data!#REF!,IF(G69=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,{"$f":"IF(J69=\"\",\"\",J69/37.5)","v":""},null,null,null,null,{"$f":"IF(N69=\"\",\"\",SUM(N69:O69))","v":""},null,null,{"$f":"IF(Q69=\"\",\"\",SUM(Q69:R69))","v":""},null,null,{"$f":"IF(T69=\"\",\"\",SUM(T69:U69))","v":""},null,null,{"$f":"IF(W69=\"\",\"\",SUM(W69:X69))","v":""},null,null,{"$f":"IF(Z69=\"\",\"\",SUM(Z69:AA69))","v":""},null,null,{"$f":"IF(AC69=\"\",\"\",SUM(AC69:AD69))","v":""},null,null,{"$f":"IF(AF69=\"\",\"\",SUM(AF69:AG69))","v":""},null,null,{"$f":"IF(AI69=\"\",\"\",SUM(AI69:AJ69))","v":""},null,null,{"$f":"IF(AL69=\"\",\"\",SUM(AL69:AM69))","v":""},null,null,{"$f":"IF(AO69=\"\",\"\",SUM(AO69:AP69))","v":""},null,null,{"$f":"IF(AR69=\"\",\"\",SUM(AR69:AS69))","v":""},null,null,{"$f":"IF(AU69=\"\",\"\",SUM(AU69:AV69))","v":""},""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D70,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D70<>'ARRS Summary'!B$30,\"\",IF(D70='ARRS Summary'!B$30,IF(G70=Data!B$5,Data!#REF!,IF(G70=Data!B$6,Data!#REF!,IF(G70=Data!B$7,Data!#REF!,IF(G70=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",{"$f":"IF(AW70=\"\",\"\",SUM(AW70,AT70,AQ70,AN70,AK70,AH70,AE70,AB70,Y70,V70,S70,P70))","v":""}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D71,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D71<>'ARRS Summary'!B$30,\"\",IF(D71='ARRS Summary'!B$30,IF(G71=Data!B$5,Data!#REF!,IF(G71=Data!B$6,Data!#REF!,IF(G71=Data!B$7,Data!#REF!,IF(G71=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D72,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D72<>'ARRS Summary'!B$30,\"\",IF(D72='ARRS Summary'!B$30,IF(G72=Data!B$5,Data!#REF!,IF(G72=Data!B$6,Data!#REF!,IF(G72=Data!B$7,Data!#REF!,IF(G72=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D73,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D73<>'ARRS Summary'!B$30,\"\",IF(D73='ARRS Summary'!B$30,IF(G73=Data!B$5,Data!#REF!,IF(G73=Data!B$6,Data!#REF!,IF(G73=Data!B$7,Data!#REF!,IF(G73=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D74,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D74<>'ARRS Summary'!B$30,\"\",IF(D74='ARRS Summary'!B$30,IF(G74=Data!B$5,Data!#REF!,IF(G74=Data!B$6,Data!#REF!,IF(G74=Data!B$7,Data!#REF!,IF(G74=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D75,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D75<>'ARRS Summary'!B$30,\"\",IF(D75='ARRS Summary'!B$30,IF(G75=Data!B$5,Data!#REF!,IF(G75=Data!B$6,Data!#REF!,IF(G75=Data!B$7,Data!#REF!,IF(G75=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D76,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D76<>'ARRS Summary'!B$30,\"\",IF(D76='ARRS Summary'!B$30,IF(G76=Data!B$5,Data!#REF!,IF(G76=Data!B$6,Data!#REF!,IF(G76=Data!B$7,Data!#REF!,IF(G76=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D77,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D77<>'ARRS Summary'!B$30,\"\",IF(D77='ARRS Summary'!B$30,IF(G77=Data!B$5,Data!#REF!,IF(G77=Data!B$6,Data!#REF!,IF(G77=Data!B$7,Data!#REF!,IF(G77=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D78,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D78<>'ARRS Summary'!B$30,\"\",IF(D78='ARRS Summary'!B$30,IF(G78=Data!B$5,Data!#REF!,IF(G78=Data!B$6,Data!#REF!,IF(G78=Data!B$7,Data!#REF!,IF(G78=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D79,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D79<>'ARRS Summary'!B$30,\"\",IF(D79='ARRS Summary'!B$30,IF(G79=Data!B$5,Data!#REF!,IF(G79=Data!B$6,Data!#REF!,IF(G79=Data!B$7,Data!#REF!,IF(G79=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D80,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D80<>'ARRS Summary'!B$30,\"\",IF(D80='ARRS Summary'!B$30,IF(G80=Data!B$5,Data!#REF!,IF(G80=Data!B$6,Data!#REF!,IF(G80=Data!B$7,Data!#REF!,IF(G80=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D81,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D81<>'ARRS Summary'!B$30,\"\",IF(D81='ARRS Summary'!B$30,IF(G81=Data!B$5,Data!#REF!,IF(G81=Data!B$6,Data!#REF!,IF(G81=Data!B$7,Data!#REF!,IF(G81=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D82,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D82<>'ARRS Summary'!B$30,\"\",IF(D82='ARRS Summary'!B$30,IF(G82=Data!B$5,Data!#REF!,IF(G82=Data!B$6,Data!#REF!,IF(G82=Data!B$7,Data!#REF!,IF(G82=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D83,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D83<>'ARRS Summary'!B$30,\"\",IF(D83='ARRS Summary'!B$30,IF(G83=Data!B$5,Data!#REF!,IF(G83=Data!B$6,Data!#REF!,IF(G83=Data!B$7,Data!#REF!,IF(G83=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D84,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D84<>'ARRS Summary'!B$30,\"\",IF(D84='ARRS Summary'!B$30,IF(G84=Data!B$5,Data!#REF!,IF(G84=Data!B$6,Data!#REF!,IF(G84=Data!B$7,Data!#REF!,IF(G84=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D85,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D85<>'ARRS Summary'!B$30,\"\",IF(D85='ARRS Summary'!B$30,IF(G85=Data!B$5,Data!#REF!,IF(G85=Data!B$6,Data!#REF!,IF(G85=Data!B$7,Data!#REF!,IF(G85=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D86,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D86<>'ARRS Summary'!B$30,\"\",IF(D86='ARRS Summary'!B$30,IF(G86=Data!B$5,Data!#REF!,IF(G86=Data!B$6,Data!#REF!,IF(G86=Data!B$7,Data!#REF!,IF(G86=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D87,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D87<>'ARRS Summary'!B$30,\"\",IF(D87='ARRS Summary'!B$30,IF(G87=Data!B$5,Data!#REF!,IF(G87=Data!B$6,Data!#REF!,IF(G87=Data!B$7,Data!#REF!,IF(G87=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D88,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D88<>'ARRS Summary'!B$30,\"\",IF(D88='ARRS Summary'!B$30,IF(G88=Data!B$5,Data!#REF!,IF(G88=Data!B$6,Data!#REF!,IF(G88=Data!B$7,Data!#REF!,IF(G88=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D89,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D89<>'ARRS Summary'!B$30,\"\",IF(D89='ARRS Summary'!B$30,IF(G89=Data!B$5,Data!#REF!,IF(G89=Data!B$6,Data!#REF!,IF(G89=Data!B$7,Data!#REF!,IF(G89=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D90,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D90<>'ARRS Summary'!B$30,\"\",IF(D90='ARRS Summary'!B$30,IF(G90=Data!B$5,Data!#REF!,IF(G90=Data!B$6,Data!#REF!,IF(G90=Data!B$7,Data!#REF!,IF(G90=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D91,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D91<>'ARRS Summary'!B$30,\"\",IF(D91='ARRS Summary'!B$30,IF(G91=Data!B$5,Data!#REF!,IF(G91=Data!B$6,Data!#REF!,IF(G91=Data!B$7,Data!#REF!,IF(G91=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D92,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D92<>'ARRS Summary'!B$30,\"\",IF(D92='ARRS Summary'!B$30,IF(G92=Data!B$5,Data!#REF!,IF(G92=Data!B$6,Data!#REF!,IF(G92=Data!B$7,Data!#REF!,IF(G92=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D93,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D93<>'ARRS Summary'!B$30,\"\",IF(D93='ARRS Summary'!B$30,IF(G93=Data!B$5,Data!#REF!,IF(G93=Data!B$6,Data!#REF!,IF(G93=Data!B$7,Data!#REF!,IF(G93=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D94,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D94<>'ARRS Summary'!B$30,\"\",IF(D94='ARRS Summary'!B$30,IF(G94=Data!B$5,Data!#REF!,IF(G94=Data!B$6,Data!#REF!,IF(G94=Data!B$7,Data!#REF!,IF(G94=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D95,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D95<>'ARRS Summary'!B$30,\"\",IF(D95='ARRS Summary'!B$30,IF(G95=Data!B$5,Data!#REF!,IF(G95=Data!B$6,Data!#REF!,IF(G95=Data!B$7,Data!#REF!,IF(G95=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D96,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D96<>'ARRS Summary'!B$30,\"\",IF(D96='ARRS Summary'!B$30,IF(G96=Data!B$5,Data!#REF!,IF(G96=Data!B$6,Data!#REF!,IF(G96=Data!B$7,Data!#REF!,IF(G96=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D97,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D97<>'ARRS Summary'!B$30,\"\",IF(D97='ARRS Summary'!B$30,IF(G97=Data!B$5,Data!#REF!,IF(G97=Data!B$6,Data!#REF!,IF(G97=Data!B$7,Data!#REF!,IF(G97=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D98,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D98<>'ARRS Summary'!B$30,\"\",IF(D98='ARRS Summary'!B$30,IF(G98=Data!B$5,Data!#REF!,IF(G98=Data!B$6,Data!#REF!,IF(G98=Data!B$7,Data!#REF!,IF(G98=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D99,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D99<>'ARRS Summary'!B$30,\"\",IF(D99='ARRS Summary'!B$30,IF(G99=Data!B$5,Data!#REF!,IF(G99=Data!B$6,Data!#REF!,IF(G99=Data!B$7,Data!#REF!,IF(G99=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D100,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D100<>'ARRS Summary'!B$30,\"\",IF(D100='ARRS Summary'!B$30,IF(G100=Data!B$5,Data!#REF!,IF(G100=Data!B$6,Data!#REF!,IF(G100=Data!B$7,Data!#REF!,IF(G100=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D101,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D101<>'ARRS Summary'!B$30,\"\",IF(D101='ARRS Summary'!B$30,IF(G101=Data!B$5,Data!#REF!,IF(G101=Data!B$6,Data!#REF!,IF(G101=Data!B$7,Data!#REF!,IF(G101=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,{"$f":"IF(J101=\"\",\"\",J101/37.5)","v":""},null,null,null,null,{"$f":"IF(N101=\"\",\"\",SUM(N101:O101))","v":""},null,null,{"$f":"IF(Q101=\"\",\"\",SUM(Q101:R101))","v":""},null,null,{"$f":"IF(T101=\"\",\"\",SUM(T101:U101))","v":""},null,null,{"$f":"IF(W101=\"\",\"\",SUM(W101:X101))","v":""},null,null,{"$f":"IF(Z101=\"\",\"\",SUM(Z101:AA101))","v":""},null,null,{"$f":"IF(AC101=\"\",\"\",SUM(AC101:AD101))","v":""},null,null,{"$f":"IF(AF101=\"\",\"\",SUM(AF101:AG101))","v":""},null,null,{"$f":"IF(AI101=\"\",\"\",SUM(AI101:AJ101))","v":""},null,null,{"$f":"IF(AL101=\"\",\"\",SUM(AL101:AM101))","v":""},null,null,{"$f":"IF(AO101=\"\",\"\",SUM(AO101:AP101))","v":""},null,null,{"$f":"IF(AR101=\"\",\"\",SUM(AR101:AS101))","v":""},null,null,{"$f":"IF(AU101=\"\",\"\",SUM(AU101:AV101))","v":""},""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D102,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D102<>'ARRS Summary'!B$30,\"\",IF(D102='ARRS Summary'!B$30,IF(G102=Data!B$5,Data!#REF!,IF(G102=Data!B$6,Data!#REF!,IF(G102=Data!B$7,Data!#REF!,IF(G102=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D103,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D103<>'ARRS Summary'!B$30,\"\",IF(D103='ARRS Summary'!B$30,IF(G103=Data!B$5,Data!#REF!,IF(G103=Data!B$6,Data!#REF!,IF(G103=Data!B$7,Data!#REF!,IF(G103=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D104,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D104<>'ARRS Summary'!B$30,\"\",IF(D104='ARRS Summary'!B$30,IF(G104=Data!B$5,Data!#REF!,IF(G104=Data!B$6,Data!#REF!,IF(G104=Data!B$7,Data!#REF!,IF(G104=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D105,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D105<>'ARRS Summary'!B$30,\"\",IF(D105='ARRS Summary'!B$30,IF(G105=Data!B$5,Data!#REF!,IF(G105=Data!B$6,Data!#REF!,IF(G105=Data!B$7,Data!#REF!,IF(G105=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(D106,Data!F$4:H$21,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D106<>'ARRS Summary'!B$30,\"\",IF(D106='ARRS Summary'!B$30,IF(G106=Data!B$5,Data!#REF!,IF(G106=Data!B$6,Data!#REF!,IF(G106=Data!B$7,Data!#REF!,IF(G106=Data!B$8,Data!#REF!,\"\"))))))","v":""},null,"",null,null,null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",""]

{"sheet":"All Funding Streams","index":4,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[[6,4,6,5],[6,8,6,10],[0,10,0,17],[3,4,3,5],[4,4,4,5],[5,4,5,5],[3,8,3,10],[4,8,4,10],[5,8,5,10],[0,1,1,7],[11,4,11,5],[7,4,7,5],[7,8,7,10],[20,1,23,7],[16,4,16,5],[17,4,17,5],[18,4,18,5],[8,8,8,10],[9,4,9,5],[9,8,9,10],[12,4,12,5],[13,1,13,7],[14,4,14,5],[14,8,14,10],[12,8,12,10],[10,4,10,5]]}
[null,{"$f":"\"Known National PCN Funding Streams - Indicative Values (2023/24) for \"&Home!D4","v":"Known National PCN Funding Streams - Indicative Values (2023/24) for "}]
[]
[]
[null,"Funding Stream","Basis","Paid to","Calculated as",null,"PCN Total","Monthly","Notes"]
[null,"Core PCN Funding","Actual","PCN","£1.50 per reg'd pt",null,{"$f":"IF(Home!D4=\"\",\"\",1.5*Home!K4)","v":""},{"$f":"IF(G5=\"\",\"\",G5/12)","v":""},"Use of funding at PCN discretion"]
[null,"Clinical Director Funding","Actual","PCN","£0.729 per reg'd pt",null,{"$f":"IF(G5=\"\",\"\",(0.729*Home!K4))","v":""},{"$f":"IF(G6=\"\",\"\",G6/12)","v":""},"Use of funding at PCN discretion"]
[null,"Leadership and Management","Actual","PCN","£0.684 per adjusted pt",null,{"$f":"IF(G5=\"\",\"\",(0.684*Home!L4))","v":""},{"$f":"IF(G7=\"\",\"\",G7/12)","v":""},"Use of funding at PCN discretion"]
[null,"Enhanced Access","Actual","PCN","£7.578 per adjusted pt",null,{"$f":"IF(G7=\"\",\"\",7.578*Home!L4)","v":""},{"$f":"IF(G8=\"\",\"\",G8/12)","v":""},"Delivery plan approved by ICB for each PCN"]
[null,"Care Home Premium","Indicative","PCN","Enter Bed Nos:",null,{"$f":"IF(F9=\"\",\"Enter beds\",F9*120)","v":"Enter beds"},{"$f":"IF(G9=\"Enter beds\",0,G9/12)","v":0},"Please enter indicative CQC bed numbers for the year to calculate"]
[null,"Investment and Impact Fund","Indicative","PCN","Personalise on IIF tab",null,{"$f":"IF(G7=\"\",\"\",IIF!I7)","v":""},null,"Not paid monthly. Actuals based on performance & prevalence (See IIF tab). Paid Summer 2024"]
[null,"Capacity and Access Support","Actual","PCN","£2.765 per adjusted pt",null,{"$f":"IF(Home!$K$4=\"\",\"\",2.765*Home!$L$4)","v":""},{"$f":"IF(G11=\"\",\"\",G11/12)","v":""},"Will be paid in monthly instalments"]
[null,"Capacity and Access Improvement","Indicative","PCN","£1.185 per adjusted pt",null,{"$f":"IF(Home!$K$4=\"\",\"\",1.185*Home!$L$4)","v":""},null,"Not paid monthly. Actuals based on ICB assessment of PCNs improvement plan. Paid Summer 2024"]
[null,"Network Participation Payment","Actual","Practices","£1.761 per weighted pt",null,{"$f":"IF(G7=\"\",\"\",Home!J4*1.761)","v":""},{"$f":"IF(G13=\"\",\"\",G13/12)","v":""},"Paid directly to practices, not PCN account"]
[null,"PLUS: Local PCN Funding Streams"]
[null,"Transformation Funding","Indicative","PCN","c.£1.99 per 2016 reg'd pts",null,{"$f":"IF(G7=\"\",\"\",(1.99467)*(VLOOKUP(Home!D4,PCNs[#All],4,FALSE)))","v":""},{"$f":"IF(G15=\"\",\"\",G15/12)","v":""},"This has been inflated by 2.9% for 2023/24 and is under an MoU with the ICS"]
[]
[null,null,null,null,"Total of non ARR:",null,{"$f":"IF(G5=\"\",\"\",SUM(G5:G15))","v":""}]
[null,null,null,null,"PLUS ARR:",null,{"$f":"'ARRS Summary'!D6","v":""}]
[null,null,null,null,"Total of all funding:",null,{"$f":"SUM(G17:G18)","v":0}]
[]
[null,"Other funding for Gloucestershire PCNs include: Quality Improvement, Primary Care Training Hub initiatives (e.g. HEE education funding) and PCN Development Funds. To check your PCN has accessed all available funds, contact the ICB PCN team at their mailbox."]

{"sheet":"IIF","index":5,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":true,"merged":[[1,9,1,10]]}
[null,{"$f":"IF(Home!D4=\"\",\"IIF Indicator Summary 23/24\",\"IIF Indicator - summary for 23/24 for \"&Home!D4 & \"\n(NOTE: Remember that actual income also dependent upon prevalence)\" )","v":"IIF Indicator Summary 23/24"},"Lower Threshold","Upper Threshold","Points","Desired Direction","Approx max income/ indicator","Target PCN aiming for","Approx. income for chosen target"]
[null,"ACC-08: % of appointments where time from booking to appointment was two weeks or less",0.85,0.9,71,"Up",{"$f":"IF(Home!$D$4=\"\",E2*198,E2*198/49000*Home!$K$4)","v":14058},0.9,{"$f":"IF(H2>=D2,G2,IF(H2<=C2,0,ROUND((E2/SUM(D2-C2)),0)*(H2-C2)*(G2/E2)))","v":14058}]
[null,"CAN-02: % of lower GI 2-wk wait (fast track) cancer referrals accompanied by a FIT result, with the result recorded either in the 21 days leading up to the referral",0.65,0.8,22,"Up",{"$f":"IF(Home!$D$4=\"\",E3*198,E3*198/49000*Home!$K$4)","v":4356},0.8,{"$f":"IF(IF(H3>=D3,G3,IF(H3<=C3,0,ROUND((E3/SUM(D3-C3)),0)*(H3-C3)*(G3/E3)))>G3,G3,IF(H3>=D3,G3,IF(H3<=C3,0,ROUND((E3/SUM(D3-C3)),0)*(H3-C3)*(G3/E3))))","v":4356}]
[null,"HI-03: % of QOF reg'd LD patients >=14y with annual LD H/Check and completed Health Action Plan in addition to recording of ethnicity",0.6,0.8,36,"Up",{"$f":"IF(Home!$D$4=\"\",E4*198,E4*198/49000*Home!$K$4)","v":7128},0.8,7128]
[null,"VI-02: % 18-64y + clinical at-risk received a flu vaccination 01/09/23-31/03/24",0.72,0.9,113,"Up",{"$f":"IF(Home!$D$4=\"\",E5*198,E5*198/49000*Home!$K$4)","v":22374},0.9,22374]
[null,"VI-03: % 2-3y (on 31/08/23) received a flu vaccination 01/09/23-31/03/24",0.64,0.82,20,"Up",{"$f":"IF(Home!$D$4=\"\",E6*198,E6*198/49000*Home!$K$4)","v":3960},0.82,{"$f":"IF(IF(H6>=D6,G6,IF(H6<=C6,0,ROUND((E6/SUM(D6-C6)),0)*(H6-C6)*(G6/E6)))>G6,G6,IF(H6>=D6,G6,IF(H6<=C6,0,ROUND((E6/SUM(D6-C6)),0)*(H6-C6)*(G6/E6))))","v":3960}]
[null,null,null,null,{"$f":"SUM(E2:E6)","v":262},null,{"$f":"SUM(G2:G6)","v":51876},null,{"$f":"SUM(I2:I6)","v":51876}]

{"sheet":"Data","index":6,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"MHP Bands Dropdown",null,"Months Dropdown",null,"Role","AfC Band","2023/24",null,"PCN","W. List   (Jan 23)","Actual List Size (Jan 23)","2016 reg'd pop'n","Adj'd pop'n 23/24"]
[null,4,null,"April",null,"Clinical Pharmacist","7-8a",59312,null,"Aspen",30142.25,30560,29694,31488.514007382961]
[null,5,null,"May",null,"Pharmacy Technician",5,38187,null,"Berkeley Vale",49627.85,{"$f":"42304+5284","v":47588},43861,45133.927007634898]
[null,6,null,"June",null,"Paramedic",7,57465,null,"Central",52829.48,57201,52342,54371.843022810601]
[null,7,null,"July",null,"Physiotherapist","7-8a",59312,null,"Forest of Dean",73727.02,65608,62864,67099.549339941295]
[null,"8a",null,"Aug",null,"Social Prescribing Link Worker",5,{"$f":"H5","v":38187},null,"Hadwen & Quedgeley",22512.080000000002,25380,23178,23509.308169508298]
[null,null,null,"Sept",null,"Care Coordinator",4,31746,null,"Inner City",33378.74,35086,32119,36584.500595298203]
[null,null,null,"Oct",null,"Health and Wellbeing Coach",5,{"$f":"H5","v":38187},null,"North Cotswolds",37550.53,32839,28967,33772.340547868]
[null,"IIF Binary Indicator",null,"Nov",null,"Nursing Associate",4,{"$f":"H9","v":31746},null,"NSG",55019.21,55465,51933,53324.011238037798]
[null,"Yes",null,"Dec",null,"Trainee Nursing Associate",3,28177,null,"Peripheral",53368.82,54466,50522,52281.8563256993]
[null,"No",null,"Jan",null,"GP Assistant (GPA)",4,{"$f":"H11","v":31746},null,"Rosebank",34689.75,38199,32675,36300.510866409801]
[null,null,null,"Feb",null,"Physician Associate",7,{"$f":"H6","v":57465},null,"Severn Health",39010.18,38436,36231,37106.400000000001]
[null,null,null,"Mar",null,"Apprentice Physician Associate",5,{"$f":"H10","v":38187},null,"South Cotswolds",63837.19,61730,58074,59603.031277609502]
[null,null,null,null,null,"Occupational Therapists",7,{"$f":"H14","v":57465},null,"St Pauls",45259.23,47486,49501,46003.753199978302]
[null,null,null,null,null,"Dietitians",7,{"$f":"H16","v":57465},null,"Stroud Cotswolds",40676.080000000002,40494,39396,39050.820267916803]
[null,null,null,null,null,"Podiatrists",7,{"$f":"H17","v":57465},null,"TWNS",51325.93,50762,44643,50346.760059975299]
[null,null,null,null,null,"Advanced Practitioner","8a",65002,null,"Gloucestershire",{"$f":"SUM(K4:K18)","v":682954.34000000008},681300,{"$f":"SUM(M4:M18)","v":636000},665977.12592607096]
[null,null,null,null,null,"Digital Transformation Lead","8a",{"$f":"H19","v":65002}]
[null,null,null,null,null,"Mental Health Practitioner",6,{"$f":"23551*2","v":47102}]