{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Data","Organisations","Dashboard","Report 2","Calculated table","Vocabulary","Gears","Geometry","Setup Instructions"],"not_rendered":{"charts":2,"images":14,"macros":1,"defined_names":108},"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":6,"n_cols":18,"rows_kept":6,"merged":[[0,1,0,6]]}
[null,"3W Data Entry - Use the 3W data entry tool to add/delete entries (Menu > 3W TOOLBOX)",{"$nulls":9},"HIDE THESE COLUMNS"]
[null,null,"Add a new organisation"]
[]
[null,"Acronym","Organisation","Org Type","Sector","Activity Type","Admin Unit Name","Pcode","Beneficiaries","Concatenate","Check Duplicated Entries","PT.Concat","Count PT.Concat","PT.ID","PT.FirstID","PT.LastID.Row","PT.LstOrg","PT.Show"]
[null,"TO",{"$f":"INDEX(Organizations[],MATCH(Main3WData[[#This Row],[Acronym]],AcronymList,0),1)","v":"Testing Organisation"},{"$f":"INDEX(Organizations[],MATCH(Main3WData[[#This Row],[Acronym]],AcronymList,0),3)","v":"National NGO"},"Education","Emergency","Anbar",{"$f":"VLOOKUP(Main3WData[[#This Row],[Admin Unit Name]],AdminUnits[],2,FALSE)","v":"IQ-G01"},0,{"$f":"Main3WData[[#This Row],[Acronym]]&Main3WData[[#This Row],[Sector]]&Main3WData[[#This Row],[Activity Type]]&Main3WData[[#This Row],[Pcode]]","v":"TOEducationEmergencyIQ-G01"},{"$f":"COUNTIF(Main3WData[Concatenate],Main3WData[[#This Row],[Concatenate]])","v":1},{"$f":"Main3WData[[#This Row],[Sector]]&Main3WData[[#This Row],[Pcode]]","v":"EducationIQ-G01"},{"$f":"COUNTIF($L$5:L5,Main3WData[[#This Row],[PT.Concat]])","v":1},{"$f":"MATCH(Main3WData[[#This Row],[PT.Concat]],$L$5:L5,0)","v":1},{"$f":"Main3WData[[#This Row],[Count PT.Concat]]=1","v":true},{"$f":"MAX(($N$4:N4=Main3WData[[#This Row],[PT.ID]])*ROW($N$4:N4))","v":0},{"$f":"IF(Main3WData[[#This Row],[PT.FirstID]],Main3WData[[#This Row],[Acronym]],INDEX($Q$4:Q4,Main3WData[[#This Row],[PT.LastID.Row]]-ROW($Q$4)+1) & \", \"&Main3WData[[#This Row],[Acronym]])","v":"TO"},{"$f":"MAX(IF(Main3WData[PT.ID]=Main3WData[[#This Row],[PT.ID]],Main3WData[PT.LastID.Row]))=Main3WData[[#This Row],[PT.LastID.Row]]","v":true}]
[null,"TO",{"$f":"INDEX(Organizations[],MATCH(Main3WData[[#This Row],[Acronym]],AcronymList,0),1)","v":"Testing Organisation"},{"$f":"INDEX(Organizations[],MATCH(Main3WData[[#This Row],[Acronym]],AcronymList,0),3)","v":"National NGO"},"Education","Emergency","Dahuk",{"$f":"VLOOKUP(Main3WData[[#This Row],[Admin Unit Name]],AdminUnits[],2,FALSE)","v":"IQ-G08"},0,{"$f":"Main3WData[[#This Row],[Acronym]]&Main3WData[[#This Row],[Sector]]&Main3WData[[#This Row],[Activity Type]]&Main3WData[[#This Row],[Pcode]]","v":"TOEducationEmergencyIQ-G08"},{"$f":"COUNTIF(Main3WData[Concatenate],Main3WData[[#This Row],[Concatenate]])","v":1},{"$f":"Main3WData[[#This Row],[Sector]]&Main3WData[[#This Row],[Pcode]]","v":"EducationIQ-G08"},{"$f":"COUNTIF($L$5:L6,Main3WData[[#This Row],[PT.Concat]])","v":1},{"$f":"MATCH(Main3WData[[#This Row],[PT.Concat]],$L$5:L6,0)","v":2},{"$f":"Main3WData[[#This Row],[Count PT.Concat]]=1","v":true},{"$f":"MAX(($N$4:N5=Main3WData[[#This Row],[PT.ID]])*ROW($N$4:N5))","v":0},{"$f":"IF(Main3WData[[#This Row],[PT.FirstID]],Main3WData[[#This Row],[Acronym]],INDEX($Q$4:Q5,Main3WData[[#This Row],[PT.LastID.Row]]-ROW($Q$4)+1) & \", \"&Main3WData[[#This Row],[Acronym]])","v":"TO"},{"$f":"MAX(IF(Main3WData[PT.ID]=Main3WData[[#This Row],[PT.ID]],Main3WData[PT.LastID.Row]))=Main3WData[[#This Row],[PT.LastID.Row]]","v":true}]

{"sheet":"Organisations","index":1,"n_rows":2,"n_cols":3,"rows_kept":2}
["Name","Acronym","Type"]
["Testing Organisation","TO","National NGO"]

{"sheet":"Dashboard","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"merged":[[6,9,8,12]]}
[]
[null,"Select the type of activity you want to see in the dashboard:"]
[]
[null,"Emergency"]
[]
[null,"Go to the 3W Data Entry Page"]
[]
[null,"Standardized Scale"]
[null,"Yes"]

{"sheet":"Report 2","index":3,"n_rows":22,"n_cols":13,"rows_kept":22,"merged":[[3,12,5,13]]}
[]
[]
[]
[null,"PCODE","Governorate","Education","Food Security and Agriculture","Health","Shelter and NFIs","WASH","Protection","Emergency Telecommunication","Logistics",null,"This table updates automatically based on columns L-R from the \"Data\" sheet. On this sheet, you just need to edit sectors in row 4 and Pcodes & locations in column B & C."]
[null,"IQ-G01","Anbar",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B5)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":"TO"},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B5)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B5)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B5)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B5)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B5)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B5)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B5)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G08","Dahuk",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B6)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":"TO"},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B6)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B6)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B6)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B6)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B6)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B6)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B6)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G07","Baghdad",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B7)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B7)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B7)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B7)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B7)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B7)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B7)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B7)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G02","Basrah",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B8)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B8)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B8)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B8)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B8)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B8)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B8)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B8)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G06","Babylon",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B9)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B9)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B9)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B9)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B9)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B9)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B9)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B9)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G18","Salah al-Din",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B10)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B10)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B10)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B10)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B10)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B10)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B10)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B10)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G10","Diyala",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B11)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B11)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B11)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B11)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B11)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B11)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B11)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B11)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G12","Kerbala",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B12)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B12)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B12)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B12)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B12)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B12)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B12)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B12)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G11","Erbil",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B13)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B13)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B13)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B13)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B13)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B13)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B13)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B13)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G13","Kirkuk",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B14)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B14)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B14)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B14)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B14)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B14)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B14)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B14)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G14","Missan",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B15)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B15)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B15)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B15)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B15)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B15)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B15)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B15)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G03","Muthanna",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B16)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B16)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B16)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B16)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B16)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B16)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B16)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B16)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G17","Najaf",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B17)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B17)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B17)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B17)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B17)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B17)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B17)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B17)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G15","Ninewa",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B18)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B18)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B18)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B18)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B18)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B18)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B18)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B18)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G04","Qadissiya",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B19)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B19)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B19)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B19)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B19)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B19)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B19)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B19)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G16","Wassit",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B20)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B20)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B20)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B20)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B20)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B20)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B20)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B20)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G05","Sulaymaniyah",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B21)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B21)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B21)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B21)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B21)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B21)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B21)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B21)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]
[null,"IQ-G09","Thi-Qar",{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(D$4&$B22)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(E$4&$B22)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(F$4&$B22)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(G$4&$B22)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(H$4&$B22)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(I$4&$B22)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(J$4&$B22)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""},{"$f":"_xlfn.IFNA(INDEX(Main3WData[PT.LstOrg],MATCH(CONCATENATE(K$4&$B22)&TRUE,Main3WData[PT.Concat]&Main3WData[PT.Show],0)),\"\")","v":""}]

{"sheet":"Calculated table","index":4,"n_rows":24,"n_cols":14,"rows_kept":24,"merged":[[2,2,2,3],[2,13,11,14]]}
[]
[]
[null,{"$f":"B4","v":"Governorate"},{"$f":"C4","v":"Number of IDPs\n(Planning Figure*)"},{"$nulls":10},"This table updates automatically. You just need to edit sectors in row 4 (hidden) and locations in column B.\nA linked picture is already embeded on the dashboard."]
[null,"Governorate","Number of IDPs\n(Planning Figure*)","Column1","Education","Food Security and Agriculture","Health","Shelter and NFIs","WASH","Protection","Emergency Telecommunication","Logistics"]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B5))","v":"Anbar"},{"$f":"Table11[[#This Row],[Column1]]","v":362238},{"v":362238,"d":"362,238"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":1},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B6))","v":"Dahuk"},{"$f":"Table11[[#This Row],[Column1]]","v":452004},{"v":452004,"d":"452,004"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":1},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B7))","v":"Baghdad"},{"$f":"Table11[[#This Row],[Column1]]","v":127446},{"v":127446,"d":"127,446"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B8))","v":"Basrah"},{"$f":"Table11[[#This Row],[Column1]]","v":8712},{"v":8712,"d":"8,712"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B9))","v":"Babylon"},{"$f":"Table11[[#This Row],[Column1]]","v":31806},{"v":31806,"d":"31,806"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B10))","v":"Salah al-Din"},{"$f":"Table11[[#This Row],[Column1]]","v":43086},{"v":43086,"d":"43,086"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B11))","v":"Diyala"},{"$f":"Table11[[#This Row],[Column1]]","v":75498},{"v":75498,"d":"75,498"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B12))","v":"Kerbala"},{"$f":"Table11[[#This Row],[Column1]]","v":63528},{"v":63528,"d":"63,528"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B13))","v":"Erbil"},{"$f":"Table11[[#This Row],[Column1]]","v":156522},{"v":156522,"d":"156,522"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B14))","v":"Kirkuk"},{"$f":"Table11[[#This Row],[Column1]]","v":171204},{"v":171204,"d":"171,204"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B15))","v":"Missan"},{"$f":"Table11[[#This Row],[Column1]]","v":6750},{"v":6750,"d":"6,750"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B16))","v":"Muthanna"},{"$f":"Table11[[#This Row],[Column1]]","v":0},0,{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B17))","v":"Najaf"},{"$f":"Table11[[#This Row],[Column1]]","v":80232},{"v":80232,"d":"80,232"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B18))","v":"Ninewa"},{"$f":"Table11[[#This Row],[Column1]]","v":165858},{"v":165858,"d":"165,858"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B19))","v":"Qadissiya"},{"$f":"Table11[[#This Row],[Column1]]","v":16302},{"v":16302,"d":"16,302"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B20))","v":"Wassit"},{"$f":"Table11[[#This Row],[Column1]]","v":27900},{"v":27900,"d":"27,900"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B21))","v":"Sulaymaniyah"},{"$f":"Table11[[#This Row],[Column1]]","v":100968},{"v":100968,"d":"100,968"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[null,{"$f":"INDEX(AdminNamesList,ROWS($B$5:B22))","v":"Thi-Qar"},{"$f":"Table11[[#This Row],[Column1]]","v":8790},{"v":8790,"d":"8,790"},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!E$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!F$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!G$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!H$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!I$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!J$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!K$4,Gears!$C$5:$J$5,0))","v":0},{"$f":"INDEX(Gears!$C$6:$J$23,MATCH(Table11[[#This Row],[Governorate]],Gears!$A$6:$A$23,0),MATCH('Calculated table'!L$4,Gears!$C$5:$J$5,0))","v":0}]
[]
[null,"*Planning Figure as at 26 October 2014."]

{"sheet":"Vocabulary","index":5,"n_rows":19,"n_cols":21,"rows_kept":19,"merged":[[4,3,4,6],[7,13,7,16],[9,13,10,16]]}
[null,"Sector",null,"Activity Type","ID","TitleBarText","Dashboard Text",null,"Organiztion Type",null,"AdminName","Pcode",null,"R","G","B","Color",null,"Number of Dashboard Maps",null,"Is Setup Complete"]
[null,"Education",null,"Regular",3,"Regular Programs","Organisations working in Iraq",null,"Donor",null,"Anbar","IQ-G01",null,255,255,255,"sample color",null,{"$f":"COUNTA(Sectors[]) + 1","v":9},null,true]
[null,"Food Security and Agriculture",null,"Emergency",2,"Emergency Programs","Organisations working in Iraq",null,"Development",null,"Dahuk","IQ-G08",null,199,214,238,"sample color"]
[null,"Health",null,"All Programs",1,"","Organisations working in Iraq",null,"Regional Entities",null,"Baghdad","IQ-G07",null,149,182,223,"sample color"]
[null,"Shelter and NFIs",null,"DO NOT ADD MORE ROWS TO THIS TABLE",{"$nulls":4},"Government",null,"Basrah","IQ-G02",null,101,154,210,"sample color"]
[null,"WASH",{"$nulls":6},"International NGO",null,"Babylon","IQ-G06",null,2,108,182,"sample color"]
[null,"Protection",{"$nulls":6},"National NGO",null,"Salah al-Din","IQ-G18",null,0,52,105,"sample color"]
[null,"Emergency Telecommunication",{"$nulls":6},"UN",null,"Diyala","IQ-G10",null,"DO NOT ADD MORE ROWS TO THIS TABLE"]
[null,"Logistics",{"$nulls":8},"Kerbala","IQ-G12"]
[{"$nulls":10},"Erbil","IQ-G11",null,"Color Ramp for Master Map"]
[null,"Limit of 12 Sectors",{"$nulls":8},"Kirkuk","IQ-G13"]
[{"$nulls":10},"Missan","IQ-G14",null,"R","G","B","Color"]
[{"$nulls":10},"Muthanna","IQ-G03",null,255,255,255,"sample color"]
[{"$nulls":10},"Najaf","IQ-G17",null,254,226,202,"sample color"]
[{"$nulls":10},"Ninewa","IQ-G15",null,252,200,159,"sample color"]
[{"$nulls":10},"Qadissiya","IQ-G04",null,250,174,119,"sample color"]
[{"$nulls":10},"Wassit","IQ-G16",null,247,149,82,"sample color"]
[{"$nulls":10},"Sulaymaniyah","IQ-G05",null,241,90,34,"sample color"]
[{"$nulls":10},"Thi-Qar","IQ-G09"]

{"sheet":"Gears","index":6,"n_rows":46,"n_cols":33,"rows_kept":46}
[]
[]
[{"$nulls":15},"Color Classification"]
["Unique Orgs by Admin Unit and Sector",{"$nulls":10},"Unique Orgs by Admin Unit and Activity Type",{"$nulls":3},"All Sectors",null,"Education",null,"Food Security and Agriculture",null,"Health",null,"Shelter and NFIs",null,"WASH",null,"Protection",null,"Emergency Telecommunication",null,"Logistics"]
["AdminName","Pcode","Education","Food Security and Agriculture","Health","Shelter and NFIs","WASH","Protection","Emergency Telecommunication","Logistics",null,"Regular","Emergency","All Programs",null,"Current Activity Type","Bins","Rank","Bins","Rank","Bins","Rank","Bins","Rank","Bins","Rank","Bins","Rank","Bins","Rank","Bins","Rank","Bins"]
["Anbar","IQ-G01",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A6,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A6))","v":1},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A6,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A6))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A6,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A6))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A6,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A6))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A6,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A6))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A6,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A6))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A6,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A6))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A6,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A6))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B6),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B6),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B6),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B6),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":1},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B6),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B6),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":1},null,{"$f":"IF(M6=0,1,IFERROR(MATCH(M6,$Q$6:$Q$10,1)+1,1))","v":6},{"$f":"MIN(IF(OrgByAdmin_Emg>0,OrgByAdmin_Emg))","v":1},{"$f":"IF(INDEX(SectorCount0,1)=0,1,MATCH(INDEX(SectorCount0,1),SectorCountBins0,1)+1)","v":6},{"$f":"IF(StdScale=\"Yes\",1,MIN(IF(SectorCount0>0,SectorCount0)))","v":1},{"$f":"IF(INDEX(SectorCount1,1)=0,1,MATCH(INDEX(SectorCount1,1),SectorCountBins1,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",1,MIN(IF(SectorCount1>0,SectorCount1)))","v":1},{"$f":"IF(INDEX(SectorCount2,1)=0,1,MATCH(INDEX(SectorCount2,1),SectorCountBins2,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",1,MIN(IF(SectorCount2>0,SectorCount2)))","v":1},{"$f":"IF(INDEX(SectorCount3,1)=0,1,MATCH(INDEX(SectorCount3,1),SectorCountBins3,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",1,MIN(IF(SectorCount3>0,SectorCount3)))","v":1},{"$f":"IF(INDEX(SectorCount4,1)=0,1,MATCH(INDEX(SectorCount4,1),SectorCountBins4,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",1,MIN(IF(SectorCount4>0,SectorCount4)))","v":1},{"$f":"IF(INDEX(SectorCount5,1)=0,1,MATCH(INDEX(SectorCount5,1),SectorCountBins5,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",1,MIN(IF(SectorCount5>0,SectorCount5)))","v":1},{"$f":"IF(INDEX(SectorCount6,1)=0,1,MATCH(INDEX(SectorCount6,1),SectorCountBins6,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",1,MIN(IF(SectorCount6>0,SectorCount6)))","v":1},{"$f":"IF(INDEX(SectorCount7,1)=0,1,MATCH(INDEX(SectorCount7,1),SectorCountBins7,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",1,MIN(IF(SectorCount7>0,SectorCount7)))","v":1}]
["Dahuk","IQ-G08",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A7,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A7))","v":1},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A7,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A7))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A7,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A7))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A7,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A7))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A7,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A7))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A7,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A7))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A7,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A7))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A7,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A7))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B7),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B7),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B7),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B7),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":1},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B7),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B7),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":1},null,6,{"$f":"$Q$6+(0/4)","v":1},{"$f":"IF(INDEX(SectorCount0,2)=0,1,MATCH(INDEX(SectorCount0,2),SectorCountBins0,1)+1)","v":6},{"$f":"$S$6+($S$10-$S$6)/4","v":1},{"$f":"IF(INDEX(SectorCount1,2)=0,1,MATCH(INDEX(SectorCount1,2),SectorCountBins1,1)+1)","v":1},{"$f":"$U$6+($U$10-$U$6)/4","v":1},{"$f":"IF(INDEX(SectorCount2,2)=0,1,MATCH(INDEX(SectorCount2,2),SectorCountBins2,1)+1)","v":1},{"$f":"$W$6+($W$10-$W$6)/4","v":1},{"$f":"IF(INDEX(SectorCount3,2)=0,1,MATCH(INDEX(SectorCount3,2),SectorCountBins3,1)+1)","v":1},{"$f":"$Y$6+($Y$10-$Y$6)/4","v":1},{"$f":"IF(INDEX(SectorCount4,2)=0,1,MATCH(INDEX(SectorCount4,2),SectorCountBins4,1)+1)","v":1},{"$f":"$AA$6+($AA$10-$AA$6)/4","v":1},{"$f":"IF(INDEX(SectorCount5,2)=0,1,MATCH(INDEX(SectorCount5,2),SectorCountBins5,1)+1)","v":1},{"$f":"$AC$6+($AC$10-$AC$6)/4","v":1},{"$f":"IF(INDEX(SectorCount6,2)=0,1,MATCH(INDEX(SectorCount6,2),SectorCountBins6,1)+1)","v":1},{"$f":"$AE$6+($AE$10-$AE$6)/4","v":1},{"$f":"IF(INDEX(SectorCount7,2)=0,1,MATCH(INDEX(SectorCount7,2),SectorCountBins7,1)+1)","v":1},{"$f":"$AG$6+($AG$10-$AG$6)/4","v":1}]
["Baghdad","IQ-G07",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A8,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A8))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A8,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A8))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A8,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A8))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A8,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A8))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A8,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A8))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A8,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A8))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A8,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A8))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A8,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A8))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B8),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B8),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B8),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B8),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B8),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B8),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,{"$f":"$Q$7+(0/4)","v":1},{"$f":"IF(INDEX(SectorCount0,3)=0,1,MATCH(INDEX(SectorCount0,3),SectorCountBins0,1)+1)","v":1},{"$f":"$S$7+($S$10-$S$6)/4","v":1},{"$f":"IF(INDEX(SectorCount1,3)=0,1,MATCH(INDEX(SectorCount1,3),SectorCountBins1,1)+1)","v":1},{"$f":"$U$7+($U$10-$U$6)/4","v":1},{"$f":"IF(INDEX(SectorCount2,3)=0,1,MATCH(INDEX(SectorCount2,3),SectorCountBins2,1)+1)","v":1},{"$f":"$W$7+($W$10-$W$6)/4","v":1},{"$f":"IF(INDEX(SectorCount3,3)=0,1,MATCH(INDEX(SectorCount3,3),SectorCountBins3,1)+1)","v":1},{"$f":"$Y$7+($Y$10-$Y$6)/4","v":1},{"$f":"IF(INDEX(SectorCount4,3)=0,1,MATCH(INDEX(SectorCount4,3),SectorCountBins4,1)+1)","v":1},{"$f":"$AA$7+($AA$10-$AA$6)/4","v":1},{"$f":"IF(INDEX(SectorCount5,3)=0,1,MATCH(INDEX(SectorCount5,3),SectorCountBins5,1)+1)","v":1},{"$f":"$AC$7+($AC$10-$AC$6)/4","v":1},{"$f":"IF(INDEX(SectorCount6,3)=0,1,MATCH(INDEX(SectorCount6,3),SectorCountBins6,1)+1)","v":1},{"$f":"$AE$7+($AE$10-$AE$6)/4","v":1},{"$f":"IF(INDEX(SectorCount7,3)=0,1,MATCH(INDEX(SectorCount7,3),SectorCountBins7,1)+1)","v":1},{"$f":"$AG$7+($AG$10-$AG$6)/4","v":1}]
["Basrah","IQ-G02",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A9,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A9))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A9,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A9))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A9,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A9))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A9,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A9))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A9,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A9))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A9,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A9))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A9,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A9))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A9,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A9))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B9),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B9),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B9),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B9),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B9),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B9),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,{"$f":"$Q$8+(0/4)","v":1},{"$f":"IF(INDEX(SectorCount0,4)=0,1,MATCH(INDEX(SectorCount0,4),SectorCountBins0,1)+1)","v":1},{"$f":"$S$8+($S$10-$S$6)/4","v":1},{"$f":"IF(INDEX(SectorCount1,4)=0,1,MATCH(INDEX(SectorCount1,4),SectorCountBins1,1)+1)","v":1},{"$f":"$U$8+($U$10-$U$6)/4","v":1},{"$f":"IF(INDEX(SectorCount2,4)=0,1,MATCH(INDEX(SectorCount2,4),SectorCountBins2,1)+1)","v":1},{"$f":"$W$8+($W$10-$W$6)/4","v":1},{"$f":"IF(INDEX(SectorCount3,4)=0,1,MATCH(INDEX(SectorCount3,4),SectorCountBins3,1)+1)","v":1},{"$f":"$Y$8+($Y$10-$Y$6)/4","v":1},{"$f":"IF(INDEX(SectorCount4,4)=0,1,MATCH(INDEX(SectorCount4,4),SectorCountBins4,1)+1)","v":1},{"$f":"$AA$8+($AA$10-$AA$6)/4","v":1},{"$f":"IF(INDEX(SectorCount5,4)=0,1,MATCH(INDEX(SectorCount5,4),SectorCountBins5,1)+1)","v":1},{"$f":"$AC$8+($AC$10-$AC$6)/4","v":1},{"$f":"IF(INDEX(SectorCount6,4)=0,1,MATCH(INDEX(SectorCount6,4),SectorCountBins6,1)+1)","v":1},{"$f":"$AE$8+($AE$10-$AE$6)/4","v":1},{"$f":"IF(INDEX(SectorCount7,4)=0,1,MATCH(INDEX(SectorCount7,4),SectorCountBins7,1)+1)","v":1},{"$f":"$AG$8+($AG$10-$AG$6)/4","v":1}]
["Babylon","IQ-G06",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A10,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A10))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A10,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A10))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A10,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A10))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A10,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A10))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A10,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A10))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A10,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A10))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A10,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A10))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A10,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A10))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B10),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B10),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B10),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B10),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B10),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B10),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,{"$f":"MAX(OrgByAdmin_Emg)","v":1},{"$f":"IF(INDEX(SectorCount0,5)=0,1,MATCH(INDEX(SectorCount0,5),SectorCountBins0,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",MAX(SectorCount0,SectorCount1,SectorCount2,SectorCount3,SectorCount4,SectorCount5,SectorCount6,SectorCount7),MAX(SectorCount0))","v":1},{"$f":"IF(INDEX(SectorCount1,5)=0,1,MATCH(INDEX(SectorCount1,5),SectorCountBins1,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",MAX(SectorCount0,SectorCount1,SectorCount2,SectorCount3,SectorCount4,SectorCount5,SectorCount6,SectorCount7),MAX(SectorCount1))","v":1},{"$f":"IF(INDEX(SectorCount2,5)=0,1,MATCH(INDEX(SectorCount2,5),SectorCountBins2,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",MAX(SectorCount0,SectorCount1,SectorCount2,SectorCount3,SectorCount4,SectorCount5,SectorCount6,SectorCount7),MAX(SectorCount2))","v":1},{"$f":"IF(INDEX(SectorCount3,5)=0,1,MATCH(INDEX(SectorCount3,5),SectorCountBins3,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",MAX(SectorCount0,SectorCount1,SectorCount2,SectorCount3,SectorCount4,SectorCount5,SectorCount6,SectorCount7),MAX(SectorCount3))","v":1},{"$f":"IF(INDEX(SectorCount4,5)=0,1,MATCH(INDEX(SectorCount4,5),SectorCountBins4,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",MAX(SectorCount0,SectorCount1,SectorCount2,SectorCount3,SectorCount4,SectorCount5,SectorCount6,SectorCount7),MAX(SectorCount4))","v":1},{"$f":"IF(INDEX(SectorCount5,5)=0,1,MATCH(INDEX(SectorCount5,5),SectorCountBins5,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",MAX(SectorCount0,SectorCount1,SectorCount2,SectorCount3,SectorCount4,SectorCount5,SectorCount6,SectorCount7),MAX(SectorCount5))","v":1},{"$f":"IF(INDEX(SectorCount6,5)=0,1,MATCH(INDEX(SectorCount6,5),SectorCountBins6,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",MAX(SectorCount0,SectorCount1,SectorCount2,SectorCount3,SectorCount4,SectorCount5,SectorCount6,SectorCount7),MAX(SectorCount6))","v":1},{"$f":"IF(INDEX(SectorCount7,5)=0,1,MATCH(INDEX(SectorCount7,5),SectorCountBins7,1)+1)","v":1},{"$f":"IF(StdScale=\"Yes\",MAX(SectorCount0,SectorCount1,SectorCount2,SectorCount3,SectorCount4,SectorCount5,SectorCount6,SectorCount7),MAX(SectorCount7))","v":1}]
["Salah al-Din","IQ-G18",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A11,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A11))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A11,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A11))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A11,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A11))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A11,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A11))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A11,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A11))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A11,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A11))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A11,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A11))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A11,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A11))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B11),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B11),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B11),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B11),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B11),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B11),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,6)=0,1,MATCH(INDEX(SectorCount0,6),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,6)=0,1,MATCH(INDEX(SectorCount1,6),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,6)=0,1,MATCH(INDEX(SectorCount2,6),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,6)=0,1,MATCH(INDEX(SectorCount3,6),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,6)=0,1,MATCH(INDEX(SectorCount4,6),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,6)=0,1,MATCH(INDEX(SectorCount5,6),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,6)=0,1,MATCH(INDEX(SectorCount6,6),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,6)=0,1,MATCH(INDEX(SectorCount7,6),SectorCountBins7,1)+1)","v":1}]
["Diyala","IQ-G10",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A12,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A12))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A12,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A12))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A12,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A12))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A12,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A12))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A12,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A12))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A12,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A12))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A12,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A12))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A12,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A12))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B12),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B12),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B12),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B12),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B12),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B12),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,7)=0,1,MATCH(INDEX(SectorCount0,7),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,7)=0,1,MATCH(INDEX(SectorCount1,7),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,7)=0,1,MATCH(INDEX(SectorCount2,7),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,7)=0,1,MATCH(INDEX(SectorCount3,7),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,7)=0,1,MATCH(INDEX(SectorCount4,7),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,7)=0,1,MATCH(INDEX(SectorCount5,7),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,7)=0,1,MATCH(INDEX(SectorCount6,7),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,7)=0,1,MATCH(INDEX(SectorCount7,7),SectorCountBins7,1)+1)","v":1}]
["Kerbala","IQ-G12",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A13,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A13))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A13,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A13))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A13,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A13))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A13,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A13))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A13,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A13))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A13,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A13))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A13,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A13))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A13,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A13))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B13),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B13),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B13),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B13),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B13),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B13),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,8)=0,1,MATCH(INDEX(SectorCount0,8),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,8)=0,1,MATCH(INDEX(SectorCount1,8),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,8)=0,1,MATCH(INDEX(SectorCount2,8),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,8)=0,1,MATCH(INDEX(SectorCount3,8),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,8)=0,1,MATCH(INDEX(SectorCount4,8),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,8)=0,1,MATCH(INDEX(SectorCount5,8),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,8)=0,1,MATCH(INDEX(SectorCount6,8),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,8)=0,1,MATCH(INDEX(SectorCount7,8),SectorCountBins7,1)+1)","v":1}]
["Erbil","IQ-G11",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A14,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A14))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A14,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A14))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A14,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A14))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A14,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A14))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A14,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A14))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A14,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A14))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A14,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A14))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A14,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A14))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B14),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B14),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B14),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B14),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B14),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B14),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,9)=0,1,MATCH(INDEX(SectorCount0,9),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,9)=0,1,MATCH(INDEX(SectorCount1,9),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,9)=0,1,MATCH(INDEX(SectorCount2,9),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,9)=0,1,MATCH(INDEX(SectorCount3,9),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,9)=0,1,MATCH(INDEX(SectorCount4,9),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,9)=0,1,MATCH(INDEX(SectorCount5,9),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,9)=0,1,MATCH(INDEX(SectorCount6,9),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,9)=0,1,MATCH(INDEX(SectorCount7,9),SectorCountBins7,1)+1)","v":1}]
["Kirkuk","IQ-G13",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A15,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A15))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A15,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A15))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A15,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A15))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A15,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A15))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A15,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A15))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A15,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A15))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A15,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A15))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A15,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A15))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B15),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B15),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B15),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B15),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B15),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B15),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,10)=0,1,MATCH(INDEX(SectorCount0,10),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,10)=0,1,MATCH(INDEX(SectorCount1,10),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,10)=0,1,MATCH(INDEX(SectorCount2,10),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,10)=0,1,MATCH(INDEX(SectorCount3,10),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,10)=0,1,MATCH(INDEX(SectorCount4,10),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,10)=0,1,MATCH(INDEX(SectorCount5,10),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,10)=0,1,MATCH(INDEX(SectorCount6,10),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,10)=0,1,MATCH(INDEX(SectorCount7,10),SectorCountBins7,1)+1)","v":1}]
["Missan","IQ-G14",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A16,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A16))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A16,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A16))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A16,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A16))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A16,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A16))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A16,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A16))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A16,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A16))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A16,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A16))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A16,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A16))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B16),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B16),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B16),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B16),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B16),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B16),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,11)=0,1,MATCH(INDEX(SectorCount0,11),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,11)=0,1,MATCH(INDEX(SectorCount1,11),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,11)=0,1,MATCH(INDEX(SectorCount2,11),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,11)=0,1,MATCH(INDEX(SectorCount3,11),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,11)=0,1,MATCH(INDEX(SectorCount4,11),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,11)=0,1,MATCH(INDEX(SectorCount5,11),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,11)=0,1,MATCH(INDEX(SectorCount6,11),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,11)=0,1,MATCH(INDEX(SectorCount7,11),SectorCountBins7,1)+1)","v":1}]
["Muthanna","IQ-G03",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A17,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A17))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A17,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A17))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A17,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A17))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A17,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A17))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A17,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A17))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A17,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A17))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A17,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A17))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A17,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A17))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B17),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B17),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B17),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B17),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B17),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B17),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,12)=0,1,MATCH(INDEX(SectorCount0,12),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,12)=0,1,MATCH(INDEX(SectorCount1,12),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,12)=0,1,MATCH(INDEX(SectorCount2,12),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,12)=0,1,MATCH(INDEX(SectorCount3,12),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,12)=0,1,MATCH(INDEX(SectorCount4,12),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,12)=0,1,MATCH(INDEX(SectorCount5,12),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,12)=0,1,MATCH(INDEX(SectorCount6,12),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,12)=0,1,MATCH(INDEX(SectorCount7,12),SectorCountBins7,1)+1)","v":1}]
["Najaf","IQ-G17",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A18,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A18))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A18,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A18))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A18,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A18))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A18,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A18))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A18,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A18))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A18,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A18))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A18,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A18))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A18,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A18))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B18),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B18),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B18),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B18),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B18),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B18),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,13)=0,1,MATCH(INDEX(SectorCount0,13),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,13)=0,1,MATCH(INDEX(SectorCount1,13),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,13)=0,1,MATCH(INDEX(SectorCount2,13),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,13)=0,1,MATCH(INDEX(SectorCount3,13),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,13)=0,1,MATCH(INDEX(SectorCount4,13),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,13)=0,1,MATCH(INDEX(SectorCount5,13),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,13)=0,1,MATCH(INDEX(SectorCount6,13),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,13)=0,1,MATCH(INDEX(SectorCount7,13),SectorCountBins7,1)+1)","v":1}]
["Ninewa","IQ-G15",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A19,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A19))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A19,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A19))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A19,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A19))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A19,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A19))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A19,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A19))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A19,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A19))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A19,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A19))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A19,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A19))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B19),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B19),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B19),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B19),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B19),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B19),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,14)=0,1,MATCH(INDEX(SectorCount0,14),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,14)=0,1,MATCH(INDEX(SectorCount1,14),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,14)=0,1,MATCH(INDEX(SectorCount2,14),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,14)=0,1,MATCH(INDEX(SectorCount3,14),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,14)=0,1,MATCH(INDEX(SectorCount4,14),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,14)=0,1,MATCH(INDEX(SectorCount5,14),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,14)=0,1,MATCH(INDEX(SectorCount6,14),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,14)=0,1,MATCH(INDEX(SectorCount7,14),SectorCountBins7,1)+1)","v":1}]
["Qadissiya","IQ-G04",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A20,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A20))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A20,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A20))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A20,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A20))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A20,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A20))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A20,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A20))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A20,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A20))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A20,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A20))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A20,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A20))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B20),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B20),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B20),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B20),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B20),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B20),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,15)=0,1,MATCH(INDEX(SectorCount0,15),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,15)=0,1,MATCH(INDEX(SectorCount1,15),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,15)=0,1,MATCH(INDEX(SectorCount2,15),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,15)=0,1,MATCH(INDEX(SectorCount3,15),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,15)=0,1,MATCH(INDEX(SectorCount4,15),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,15)=0,1,MATCH(INDEX(SectorCount5,15),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,15)=0,1,MATCH(INDEX(SectorCount6,15),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,15)=0,1,MATCH(INDEX(SectorCount7,15),SectorCountBins7,1)+1)","v":1}]
["Wassit","IQ-G16",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A21,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A21))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A21,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A21))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A21,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A21))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A21,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A21))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A21,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A21))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A21,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A21))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A21,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A21))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A21,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A21))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B21),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B21),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B21),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B21),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B21),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B21),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,16)=0,1,MATCH(INDEX(SectorCount0,16),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,16)=0,1,MATCH(INDEX(SectorCount1,16),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,16)=0,1,MATCH(INDEX(SectorCount2,16),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,16)=0,1,MATCH(INDEX(SectorCount3,16),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,16)=0,1,MATCH(INDEX(SectorCount4,16),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,16)=0,1,MATCH(INDEX(SectorCount5,16),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,16)=0,1,MATCH(INDEX(SectorCount6,16),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,16)=0,1,MATCH(INDEX(SectorCount7,16),SectorCountBins7,1)+1)","v":1}]
["Sulaymaniyah","IQ-G05",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A22,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A22))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A22,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A22))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A22,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A22))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A22,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A22))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A22,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A22))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A22,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A22))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A22,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A22))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A22,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A22))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B22),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B22),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B22),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B22),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B22),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B22),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,17)=0,1,MATCH(INDEX(SectorCount0,17),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,17)=0,1,MATCH(INDEX(SectorCount1,17),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,17)=0,1,MATCH(INDEX(SectorCount2,17),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,17)=0,1,MATCH(INDEX(SectorCount3,17),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,17)=0,1,MATCH(INDEX(SectorCount4,17),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,17)=0,1,MATCH(INDEX(SectorCount5,17),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,17)=0,1,MATCH(INDEX(SectorCount6,17),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,17)=0,1,MATCH(INDEX(SectorCount7,17),SectorCountBins7,1)+1)","v":1}]
["Thi-Qar","IQ-G09",{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A23,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,C$5,Data!$G:$G,$A23))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A23,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,D$5,Data!$G:$G,$A23))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A23,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,E$5,Data!$G:$G,$A23))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A23,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,F$5,Data!$G:$G,$A23))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A23,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,G$5,Data!$G:$G,$A23))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A23,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,H$5,Data!$G:$G,$A23))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A23,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,I$5,Data!$G:$G,$A23))","v":0},{"$f":"IF(Activity<>\"All Programs\",COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A23,Data!$F:$F,Activity),COUNTIFS(Data!$E:$E,J$5,Data!$G:$G,$A23))","v":0},null,{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B23),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Pcd=B23),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B23),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Pcd=B23),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Pcd=B23),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Pcd=B23),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},null,1,null,{"$f":"IF(INDEX(SectorCount0,18)=0,1,MATCH(INDEX(SectorCount0,18),SectorCountBins0,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount1,18)=0,1,MATCH(INDEX(SectorCount1,18),SectorCountBins1,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount2,18)=0,1,MATCH(INDEX(SectorCount2,18),SectorCountBins2,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount3,18)=0,1,MATCH(INDEX(SectorCount3,18),SectorCountBins3,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount4,18)=0,1,MATCH(INDEX(SectorCount4,18),SectorCountBins4,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount5,18)=0,1,MATCH(INDEX(SectorCount5,18),SectorCountBins5,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount6,18)=0,1,MATCH(INDEX(SectorCount6,18),SectorCountBins6,1)+1)","v":1},null,{"$f":"IF(INDEX(SectorCount7,18)=0,1,MATCH(INDEX(SectorCount7,18),SectorCountBins7,1)+1)","v":1}]
[]
[]
["Unique Orgs by Org Type and Activity Type"]
["Organiztion Type","Regular","Emergency","All Programs"]
["National NGO",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A28),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A28),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A28),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A28),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":1},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A28),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A28),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":1}]
["International NGO",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A29),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A29),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A29),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A29),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A29),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A29),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["Government",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A30),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A30),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A30),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A30),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A30),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A30),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["UN",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A31),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A31),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A31),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A31),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A31),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A31),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["Donor",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A32),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A32),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A32),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A32),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A32),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A32),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["Regional Entities",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A33),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A33),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A33),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A33),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A33),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A33),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["Development",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A34),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_OrgTyp=A34),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A34),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_OrgTyp=A34),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A34),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_OrgTyp=A34),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
[]
[]
["Unique Orgs by Sector and Activity Type"]
["Sector","Regular","Emergency","All Programs"]
["Education",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A39),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A39),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A39),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A39),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":1},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Sect=A39),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Sect=A39),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":1}]
["Food Security and Agriculture",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A40),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A40),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A40),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A40),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Sect=A40),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Sect=A40),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["WASH",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A41),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A41),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A41),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A41),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Sect=A41),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Sect=A41),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["Shelter and NFIs",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A42),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A42),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A42),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A42),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Sect=A42),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Sect=A42),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["Protection",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A43),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A43),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A43),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A43),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Sect=A43),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Sect=A43),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["Health",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A44),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A44),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A44),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A44),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Sect=A44),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Sect=A44),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["Emergency Telecommunication",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A45),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A45),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A45),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A45),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Sect=A45),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Sect=A45),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]
["Logistics",{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A46),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Regular\")*(Data_Sect=A46),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A46),MATCH(Data_Acro,Data_Acro,0),\"\"), IF((LEN(Data_Acro)>0)*(Data_Act=\"Emergency\")*(Data_Sect=A46),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0},{"$f":"SUM(IF(FREQUENCY(IF((LEN(Data_Acro)>0)*(Data_Sect=A46),MATCH(Data_Acro,Data_Acro,0),\"\"),IF((LEN(Data_Acro)>0)*(Data_Sect=A46),MATCH(Data_Acro,Data_Acro,0),\"\"))>0,1))","v":0}]

{"sheet":"Geometry","index":7,"n_rows":29,"n_cols":1,"rows_kept":29}
[]
["Go to instructions"]
{"$rows_empty":8}
["Paste Pcodes Below (1 Column Only)"]
["IQ01"]
["IQ08"]
["IQ07"]
["IQ02"]
["IQ06"]
["IQ18"]
["IQ10"]
["IQ12"]
["IQ11"]
["IQ13"]
["IQ14"]
["IQ03"]
["IQ17"]
["IQ15"]
["IQ04"]
["IQ16"]
["IQ05"]
["IQ09"]

{"sheet":"Setup Instructions","index":8,"n_rows":0,"n_cols":0,"rows_kept":0}