AFCU \u00b7 West Shewa Analytics \u00b7 284 Primary Cooperatives<\/title>\n \n <link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/6.0.0-beta3\/css\/all.min.css\">\n <link href=\"https:\/\/fonts.googleapis.com\/css2?family=Inter:opsz,wght@14..32,400;14..32,500;14..32,600;14..32,700;14..32,800&display=swap\" rel=\"stylesheet\">\n \n <script src=\"https:\/\/cdn.jsdelivr.net\/npm\/chart.js@4.4.0\/dist\/chart.umd.min.js\"><\/script>\n \n <script src=\"https:\/\/cdn.sheetjs.com\/xlsx-0.20.2\/package\/dist\/xlsx.full.min.js\"><\/script>\n <style>\n * {\n margin: 0;\n padding: 0;\n box-sizing: border-box;\n }\n\n body {\n background: linear-gradient(145deg, #e9ddbb 0%, #d2bf8a 100%);\n font-family: 'Inter', sans-serif;\n padding: 24px 20px;\n min-height: 100vh;\n }\n\n .dashboard-container {\n max-width: 1600px;\n margin: 0 auto;\n background: rgba(255, 252, 240, 0.96);\n backdrop-filter: blur(2px);\n border-radius: 52px;\n box-shadow: 0 30px 45px -18px rgba(0,0,0,0.4);\n border: 2px solid rgba(218, 165, 32, 0.6);\n padding: 2rem 2rem 1.8rem;\n }\n\n \/* Header with official branding *\/\n .hero-header {\n display: flex;\n align-items: center;\n justify-content: space-between;\n flex-wrap: wrap;\n gap: 20px;\n margin-bottom: 28px;\n padding-bottom: 18px;\n border-bottom: 3px solid #e8b13e;\n }\n\n .brand-logo-area {\n display: flex;\n align-items: center;\n gap: 18px;\n background: #fdf5e2;\n border-radius: 90px;\n padding-right: 32px;\n border: 1px solid #daa520;\n }\n\n .logo-circle {\n width: 80px;\n height: 80px;\n background: #fff2df;\n border-radius: 50%;\n display: flex;\n align-items: center;\n justify-content: center;\n border: 3px solid #b67d1b;\n box-shadow: 0 6px 14px rgba(0,0,0,0.1);\n }\n .logo-circle i { font-size: 44px; color: #b6461c; }\n\n .union-text h1 {\n font-size: 1.8rem;\n font-weight: 800;\n color: #952e1a;\n letter-spacing: -0.3px;\n }\n .union-text p { font-size: 0.8rem; color: #b67d1b; font-weight: 600; }\n\n .stats-chip-badge {\n background: #237a33;\n padding: 10px 28px;\n border-radius: 40px;\n color: #ffeaad;\n font-weight: 800;\n font-size: 1.1rem;\n }\n\n \/* summary panel *\/\n .summary-panel {\n background: #f3ecda;\n border-radius: 40px;\n padding: 1.5rem 2rem;\n margin: 1.5rem 0 2rem;\n border: 2px solid #dba642;\n box-shadow: inset 0 1px 6px #fff6e6, 0 12px 18px -12px #7f6130;\n }\n\n .kpi-row {\n display: flex;\n justify-content: space-between;\n flex-wrap: wrap;\n gap: 18px;\n margin-bottom: 20px;\n }\n .kpi-card {\n background: white;\n border-radius: 32px;\n padding: 1rem 2rem;\n min-width: 160px;\n text-align: center;\n box-shadow: 0 4px 12px rgba(0,0,0,0.05);\n border-left: 6px solid #daa520;\n }\n .kpi-number { font-size: 2rem; font-weight: 800; color: #1c6b2b; }\n\n .gender-badges {\n display: flex;\n gap: 24px;\n flex-wrap: wrap;\n margin: 15px 0 12px;\n }\n .male-badge { background: #2c7a3b; padding: 8px 24px; border-radius: 40px; color: white; font-weight: 700; }\n .female-badge { background: #c47d2e; padding: 8px 24px; border-radius: 40px; color: white; font-weight: 700; }\n\n \/* charts grid *\/\n .charts-grid {\n display: flex;\n flex-wrap: wrap;\n gap: 28px;\n margin: 2rem 0 2.2rem;\n }\n .chart-box {\n flex: 1 1 420px;\n background: #fffef5;\n border-radius: 36px;\n padding: 1.4rem 1.6rem;\n border: 2px solid #e6b550;\n box-shadow: 0 10px 18px -8px #b68b40;\n }\n .chart-box h3 {\n font-size: 1.4rem;\n margin-bottom: 1rem;\n color: #2c6e2c;\n display: flex;\n align-items: center;\n gap: 10px;\n border-bottom: 2px solid #f3c26b;\n padding-bottom: 10px;\n }\n .chart-canvas-container { position: relative; height: 300px; width: 100%; }\n\n \/* action bar *\/\n .action-bar {\n display: flex;\n flex-wrap: wrap;\n gap: 16px;\n margin: 1.5rem 0 1.8rem;\n align-items: center;\n }\n .btn {\n padding: 12px 28px;\n border-radius: 60px;\n font-weight: 700;\n border: none;\n cursor: pointer;\n font-size: 0.95rem;\n display: inline-flex;\n align-items: center;\n gap: 10px;\n transition: 0.2s;\n }\n .btn-excel { background: #1f6e3a; color: white; }\n .btn-excel:hover { background: #2b8a48; }\n .btn-filtered { background: #c47d2e; color: white; }\n .stats-badge-light { background: #2c5f2d; color: #ffefb9; padding: 10px 24px; border-radius: 60px; font-weight: 600; }\n\n .search-wrapper { margin: 1rem 0 1.5rem; }\n .search-wrapper input {\n width: 100%;\n padding: 16px 24px;\n border-radius: 60px;\n border: 2px solid #e2b551;\n font-size: 1rem;\n outline: none;\n background: white;\n }\n\n .table-responsive {\n overflow-x: auto;\n border-radius: 32px;\n background: #fff9ec;\n padding: 1rem;\n border: 2px solid #e8bc6e;\n margin: 1.8rem 0;\n }\n .coop-table {\n width: 100%;\n border-collapse: collapse;\n font-size: 0.85rem;\n }\n .coop-table th {\n background: #2a592a;\n color: #fcd34d;\n padding: 14px 8px;\n font-weight: 600;\n white-space: nowrap;\n }\n .coop-table td {\n padding: 10px 6px;\n border-bottom: 1px solid #eedbaf;\n color: #2f4d2f;\n }\n .coop-table tr:hover { background: #f9efda; }\n\n .footer-links {\n background: #1f5420;\n border-radius: 48px;\n padding: 2rem 2rem 1.5rem;\n margin-top: 2rem;\n color: #fef0cf;\n border-top: 4px solid #f3bc4b;\n }\n .footer-grid {\n display: flex;\n flex-wrap: wrap;\n gap: 2.5rem;\n justify-content: space-between;\n }\n .footer-col h4 {\n font-size: 1.2rem;\n border-left: 4px solid #f5bc42;\n padding-left: 12px;\n margin-bottom: 1rem;\n }\n .footer-col ul { list-style: none; }\n .footer-col li { margin: 10px 0; }\n .footer-col a {\n color: #ffefc4;\n text-decoration: none;\n display: flex;\n align-items: center;\n gap: 10px;\n font-size: 0.9rem;\n }\n .copyright {\n text-align: center;\n margin-top: 2rem;\n padding-top: 1.5rem;\n border-top: 1px dashed #f3bc42;\n font-size: 0.85rem;\n }\n .west-banner {\n background: #fac56430;\n text-align: center;\n padding: 8px;\n border-radius: 60px;\n font-weight: 600;\n margin: 12px 0 0;\n }\n @media (max-width: 700px) {\n .dashboard-container { padding: 1.2rem; }\n .kpi-card { padding: 0.6rem 1rem; min-width: 120px; }\n }\n <\/style>\n<\/head>\n<body>\n<div class=\"dashboard-container\">\n \n <div class=\"hero-header\">\n <div class=\"brand-logo-area\">\n <div class=\"logo-circle\">\n <i class=\"fas fa-tractor\"><\/i>\n <\/div>\n <div class=\"union-text\">\n <h1>Ambo Farmers’ Cooperative Union LTD <span style=\"font-size:0.9rem;\">est. 1998<\/span><\/h1>\n <p><i class=\"fas fa-globe-africa\"><\/i> www.afcu.org.et \u00b7 official cooperative data<\/p>\n <\/div>\n <\/div>\n <div class=\"stats-chip-badge\">\n <i class=\"fas fa-chart-line\"><\/i> West Shewa \u00b7 284 coops\n <\/div>\n <\/div>\n\n \n <div class=\"summary-panel\" id=\"summaryPanel\">\n <div class=\"kpi-row\">\n <div class=\"kpi-card\"><i class=\"fas fa-city\"><\/i> <div class=\"kpi-number\" id=\"totalWoredasCount\">\u2014<\/div><span>Woredas<\/span><\/div>\n <div class=\"kpi-card\"><i class=\"fas fa-handshake\"><\/i> <div class=\"kpi-number\">284<\/div><span>Primary Coops<\/span><\/div>\n <div class=\"kpi-card\"><i class=\"fas fa-chart-simple\"><\/i> <div class=\"kpi-number\" id=\"totalMembersSum\">\u2014<\/div><span>Total Members<\/span><\/div>\n <\/div>\n <div class=\"gender-badges\">\n <span class=\"male-badge\"><i class=\"fas fa-mars\"><\/i> Male members: <span id=\"totalMaleSpan\">0<\/span><\/span>\n <span class=\"female-badge\"><i class=\"fas fa-venus\"><\/i> Female members: <span id=\"totalFemaleSpan\">0<\/span><\/span>\n <\/div>\n <div class=\"west-banner\">\n <i class=\"fas fa-chart-pie\"><\/i> Woreda-wise aggregation \u00b7 284 cooperatives from official registry\n <\/div>\n <\/div>\n\n \n <div class=\"charts-grid\">\n <div class=\"chart-box\">\n <h3><i class=\"fas fa-chart-bar\"><\/i> Cooperatives per Woreda<\/h3>\n <div class=\"chart-canvas-container\">\n <canvas id=\"coopWoredaChart\"><\/canvas>\n <\/div>\n <\/div>\n <div class=\"chart-box\">\n <h3><i class=\"fas fa-users\"><\/i> Total Members per Woreda<\/h3>\n <div class=\"chart-canvas-container\">\n <canvas id=\"membersWoredaChart\"><\/canvas>\n <\/div>\n <\/div>\n <\/div>\n\n \n <div class=\"action-bar\">\n <button class=\"btn btn-excel\" id=\"exportAllBtn\"><i class=\"fas fa-file-excel\"><\/i> Export all (Excel)<\/button>\n <button class=\"btn btn-filtered\" id=\"exportFilteredBtn\"><i class=\"fas fa-filter\"><\/i> Export filtered<\/button>\n <div class=\"stats-badge-light\" id=\"rowCountDisplay\">284 entries<\/div>\n <\/div>\n\n <div class=\"search-wrapper\">\n <input type=\"text\" id=\"searchInput\" placeholder=\"🔍 Search by cooperative name, woreda, or membership date...\" autocomplete=\"off\">\n <\/div>\n\n \n <div class=\"table-responsive\">\n <table class=\"coop-table\" id=\"coopTable\">\n <thead>\n <tr><th>#<\/th><th>Cooperative Name<\/th><th>Woreda<\/th><th>Membership Date<\/th><th>Male<\/th><th>Female<\/th><th>Total Members<\/th><\/tr>\n <\/thead>\n <tbody id=\"tableBody\"><\/tbody>\n <\/table>\n <\/div>\n\n \n <div class=\"footer-links\">\n <div class=\"footer-grid\">\n <div class=\"footer-col\">\n <h4><i class=\"fas fa-seedling\"><\/i> AFCU Services<\/h4>\n <ul>\n <li><a href=\"https:\/\/www.afcu.org.et\/?page_id=26\" target=\"_blank\"><i class=\"fas fa-tractor\"><\/i> Mechanization<\/a><\/li>\n <li><a href=\"https:\/\/www.afcu.org.et\/?page_id=27\" target=\"_blank\"><i class=\"fas fa-truck\"><\/i> Input supply<\/a><\/li>\n <li><a href=\"https:\/\/www.afcu.org.et\/?page_id=29\" target=\"_blank\"><i class=\"fas fa-egg\"><\/i> Dairy farming<\/a><\/li>\n <\/ul>\n <\/div>\n <div class=\"footer-col\">\n <h4><i class=\"fas fa-info-circle\"><\/i> About Union<\/h4>\n <ul>\n <li><a href=\"https:\/\/www.afcu.org.et\/?page_id=11\" target=\"_blank\"><i class=\"fas fa-history\"><\/i> Background<\/a><\/li>\n <li><a href=\"https:\/\/www.afcu.org.et\/?page_id=9\" target=\"_blank\"><i class=\"fas fa-bullseye\"><\/i> Mission<\/a><\/li>\n <\/ul>\n <\/div>\n <\/div>\n <div class=\"copyright\">\n <i class=\"fas fa-copyright\"><\/i> 2025 Ambo Farmers Cooperative Union \u2013 Official Data Portal | www.afcu.org.et\n <\/div>\n <\/div>\n<\/div>\n\n<script>\n \/\/ --------------------------------------------------------------\n \/\/ COMPLETE DATASET (284 entries) based on provided table\n \/\/ Each entry: [SN, CoopName, Woreda, Date, Male, Female, Total]\n \/\/ --------------------------------------------------------------\n const cooperativesData = [\n [1,\"Anfaara Hoolotoo\",\"Gindabarat\",\"22\/3\/2008\",108,36,144],[2,\"Badda-Xinnoo\",\"Gindabarat\",\"24\/3\/2008\",100,2,102],[3,\"Badeessa Caandoo\",\"Gindabarat\",\"16\/3\/2008\",67,13,80],[4,\"Bakkee Qalaaxee\",\"Gindabarat\",\"22\/3\/2008\",126,15,141],[5,\"Guutoo Somboo\",\"Gindabarat\",\"24\/3\/2008\",123,20,143],[6,\"Dabaqqaa\",\"Gindabarat\",\"26\/5\/2006\",78,8,86],[7,\"Ererii Keenjoo\",\"Gindabarat\",\"8\/4\/2007\",64,1,65],[8,\"Garbii Goolee\",\"Gindabarat\",\"6\/4\/2007\",44,15,59],[9,\"Gaajoo Baddeessaa\",\"Gindabarat\",\"1\/7\/2007\",120,15,135],[10,\"Gooroo Dhoqonuu\",\"Gindabarat\",\"10\/4\/2007\",53,1,54],[11,\"Insilaalee Gaajoo\",\"Gindabarat\",\"8\/4\/2007\",64,19,83],[12,\"Mandiidaa Xunjiitii\",\"Gindabarat\",\"8\/4\/2007\",150,24,174],[13,\"Naannoo Giixiree\",\"Gindabarat\",\"8\/4\/2007\",151,15,166],[14,\"Ogobee Gaajoo\",\"Gindabarat\",\"8\/4\/2007\",49,3,52],[15,\"Waleensuu\",\"Gindabarat\",\"8\/4\/2007\",64,19,83],[16,\"Willoo Jaganfoo\",\"Gindabarat\",\"8\/4\/2007\",72,4,76],[17,\"Qarree Biitee\",\"Gindabarat\",\"26\/5\/2006\",40,25,65],[18,\"Qarree Ceekaa\",\"Gindabarat\",\"26\/5\/2006\",130,5,135],[19,\"Somboo Walisoo\",\"Gindabarat\",\"29\/1\/2004\",77,26,103],[20,\"Daannisaa Ulaa Burkii\",\"Gindabarat\",\"22\/3\/2002\",58,11,69],[21,\"Doggoma Kibbii\",\"Gindabarat\",\"26\/5\/2006\",45,0,45],[22,\"Doggomaa Yaagot\",\"Gindabarat\",\"26\/5\/2006\",37,0,37],[23,\"Ganda Gooroo Jaalatee\",\"Gindabarat\",\"26\/5\/2006\",118,5,123],[24,\"Guutee Andoodee\",\"Gindabarat\",\"26\/5\/2006\",120,5,125],[25,\"Oborraa\",\"Gindabarat\",\"26\/5\/2006\",93,4,97],[26,\"Haroo\",\"Gindabarat\",\"29\/1\/2004\",336,22,358],[27,\"Jammoo\",\"Gindabarat\",\"29\/1\/2004\",259,6,265],[28,\"Naannoo Gorgisii\",\"Gindabarat\",\"25\/2\/2002\",151,12,163],[29,\"Altufaa\",\"Amboo\",\"7\/4\/2007\",462,74,536],[30,\"Daandii Guddinaa\",\"Amboo\",\"2004\",109,78,187],[31,\"Awwaaroo\",\"Amboo\",\"21\/7\/1997\",657,63,720],[32,\"Biiftuu\",\"Amboo\",\"7\/4\/2007\",235,20,255],[33,\"Naannoo Goromtii\",\"Amboo\",\"8\/4\/2007\",334,69,403],[34,\"Kaarraa\",\"Amboo\",\"22\/03\/2008\",197,13,210],[35,\"Meexxii\",\"Amboo\",\"15\/02\/1991\",1128,296,1424],[36,\"Guddina Taltallee Gobaa Qilxuu\",\"Amboo\",\"10\/4\/2007\",492,109,601],[37,\"Utubaa Jireenyaa\",\"Amboo\",\"26\/05\/2006\",339,399,738],[38,\"Waliin Kaanaa Ganjii Gooroo Horee\",\"Amboo\",\"10\/4\/2007\",292,101,393],[39,\"Guddina Ilaamuu Muujjaa\",\"Amboo\",\"25\/08\/09\",505,128,633],[40,\"Waliin Guddannaa\/Goosuu\",\"Amboo\",\"2004\",89,70,159],[41,\"Walqixxee\/Biloo\",\"Amboo\",\"2004\",445,110,555],[42,\"Biqiltuu\/Abuu Gabbisaa\",\"Amboo\",\"2003\",246,58,304],[43,\"Dassee Akliiloo\",\"Amboo\",\"25\/3\/2011\",207,34,241],[44,\"Tokkummaa\/qibaa qubee\",\"Amboo\",\"2004\",122,68,190],[45,\"Agaloo Sooyyamaa\",\"Calliyaa\",\"7\/4\/2007\",426,58,484],[46,\"Cobii Daalattii\",\"Calliyaa\",\"2002\",1600,301,1901],[47,\"Haroo Hindee\",\"Calliyaa\",\"7\/4\/2007\",378,73,451],[48,\"Hoolee Siree\",\"Calliyaa\",\"7\/4\/2007\",370,23,393],[49,\"Jireenyaa\",\"Calliyaa\",\"7\/4\/2007\",358,37,395],[50,\"Raffisoo Alangaa\",\"Calliyaa\",\"9\/12\/2006\",350,230,580],[51,\"Tulluu Kosorruu\",\"Calliyaa\",\"2002\",1175,190,1365],[52,\"Abdii boruu\",\"Calliyaa\",\"7\/4\/2007\",375,49,424],[53,\"Walii Galtee Jaarsoo\",\"Calliyaa\",\"30\/08\/2010\",910,85,995],[54,\"Hundee Allee\",\"Calliyaa\",\"10\/9\/2010\",371,96,467],[55,\"Cobii Sirbaa\",\"Cobii\",\"26\/4\/2006\",1040,100,1140],[56,\"Qoricha Kootichaa\",\"Cobii\",\"8\/4\/2008\",484,41,525],[57,\"Baakkee oofuu\",\"Cobii\",\"24\/06\/09\",478,192,670],[58,\"Bolaa Dammaqaa\",\"Dirree Incinnii\",\"22\/3\/2008\",90,5,95],[59,\"Buyyaamaa Dabballee\",\"Dirree Incinnii\",\"30\/1\/2004\",239,15,254],[60,\"Gaamoo Gamballaa\",\"Dirree Incinnii\",\"3\/7\/2007\",87,4,91],[61,\"Naannoo Jidduu\",\"Dirree Incinnii\",\"24\/3\/2008\",39,2,41],[62,\"Ajoo Qarsaa Biilii\",\"Dirree Incinnii\",\"24\/3\/2008\",85,5,90],[63,\"Roggee Dagaa\",\"Dirree Incinnii\",\"22\/3\/2008\",94,7,101],[64,\"Abdii Boruu\",\"Dirree Incinnii\",\"4\/4\/2007\",64,3,67],[65,\"Arifinjoo Dagaa\",\"Dirree Incinnii\",\"4\/4\/2007\",81,3,84],[66,\"Bolaa Kalacii\",\"Dirree Incinnii\",\"2006\",132,8,140],[67,\"Buuyyamaa Qochoree\",\"Dirree Incinnii\",\"1997\",220,17,237],[68,\"Biloo Abbayyii\",\"Dirree Incinnii\",\"3\/4\/2007\",115,5,120],[69,\"Buuyyamaa Mijuu\",\"Dirree Incinnii\",\"30\/4\/2007\",138,14,152],[70,\"Naannoo Incinnii\",\"Dirree Incinnii\",\"1997\",1127,47,1174],[71,\"Tokkee Cittuu\",\"Dirree Incinnii\",\"1997\",375,100,475],[72,\"Waldoo Hindhee\",\"Dirree Incinnii\",\"27\/5\/2006\",108,8,116],[73,\"Asgorii\",\"Dandii\",\"\",1450,152,1602],[74,\"Borooddoo Laga Baatuu\",\"Dandii\",\"21\/7\/1997\",1372,280,1652],[75,\"Boddaa\",\"Dandii\",\"21\/7\/1997\",1361,169,1530],[76,\"Diimtuu Baballii\",\"Dandii\",\"2001\",401,68,469],[77,\"Faajjii Booralee\",\"Dandii\",\"30\/1\/2004\",623,131,754],[78,\"Qabaa Bareedaa\",\"Dandii\",\"21\/7\/1997\",668,50,718],[79,\"Waamuraa Meexxii\",\"Dandii\",\"21\/7\/1997\",809,78,887],[80,\"Awaash Boolee\",\"Dandii\",\"4\/4\/2007\",132,17,149],[81,\"Bajiroo\",\"Dandii\",\"23\/5\/2006\",529,103,632],[82,\"Gooroo Sokorruu\",\"Dandii\",\"4\/4\/2007\",401,21,422],[83,\"Gaarree Areeraa\",\"Dandii\",\"2006\",215,33,248],[84,\"Gaattiroo Laaftoo\",\"Dandii\",\"4\/4\/2007\",146,77,223],[85,\"Honcee Biitee\",\"Dandii\",\"22\/3\/2008\",250,125,375],[86,\"Katkata Warra Bulchii\",\"Dandii\",\"4\/4\/2007\",251,50,301],[87,\"Loqloqaa Abbaa\",\"Dandii\",\"23\/5\/2006\",241,104,345],[88,\"Sandaafaa Naannoo Warqaa\",\"Dandii\",\"4\/4\/2007\",251,44,295],[89,\"Xiraangee shubee Qallaa\",\"Dandii\",\"26\/5\/2006\",454,37,491],[90,\"Faajjii Galiilaa\",\"Dandii\",\"14\/4\/2006\",642,112,754],[91,\"Ifa Barii\",\"Dandii\",\"29\/9\/2010\",87,25,112],[92,\"Gaaleessaa Qotaa Geeshaar\",\"Dandii\",\"15\/08\/2010\",448,48,496],[93,\"Hawwii Guddina Qaqaroo Jibaat\",\"Daannoo\",\"2006\",348,10,358],[94,\"Abdii Borii\",\"Daannoo\",\"14\/01\/2007\",592,17,609],[95,\"Bakkee Finnoo\",\"Daannoo\",\"30\/02\/2005\",943,93,1036],[96,\"Baabboo Gasasoo\",\"Daannoo\",\"14\/01\/2007\",673,65,738],[97,\"Baddaa Iluu\",\"Daannoo\",\"2006\",298,20,318],[98,\"Naannoo Be'ee fi Kattaa\",\"Daannoo\",\"30\/02\/2005\",795,87,882],[99,\"Biiftuu\",\"Daannoo\",\"14\/01\/2007\",250,11,261],[100,\"Dagaagina Dirree Hujubaa\",\"Daannoo\",\"14\/01\/2007\",405,31,436],[101,\"Dirree Harrayyuu\",\"Daannoo\",\"14\/01\/2007\",468,43,511],[102,\"Dirree Daannoo\",\"Daannoo\",\"14\/01\/2007\",550,22,572],[103,\"Daannoo Roggee\",\"Daannoo\",\"1996\",546,19,565],[104,\"Guddina Awwadii Gulufaa\",\"Daannoo\",\"2006\",630,63,693],[105,\"Giddaa fi Abbuu\",\"Daannoo\",\"7\/6\/2005\",452,17,469],[106,\"Kaarraa Gannat\",\"Daannoo\",\"14\/2\/2004\",653,62,715],[107,\"Naannoo Ayyaruu\",\"Daannoo\",\"30\/02\/2005\",624,15,639],[108,\"Naannoo Qarsaa\",\"Daannoo\",\"1995\",614,27,641],[109,\"Naannoo Sayyoo\",\"Daannoo\",\"1997\",688,26,714],[110,\"Odaa Oboo\",\"Daannoo\",\"3\/5\/2005\",616,51,667],[111,\"Sayyoo Aabboo\",\"Daannoo\",\"29\/1\/2004\",672,36,708],[112,\"Safara Manzee\",\"Daannoo\",\"30\/02\/2005\",481,24,505],[113,\"Daannisaa Xanqoo\",\"Ejersa Lafoo\",\"2000\",455,201,656],[114,\"Gabaa Dilbataa\",\"Ejersa Lafoo\",\"\",1805,411,2216],[115,\"Oolankomii\",\"Ejersa Lafoo\",\"1992\",1860,447,2307],[116,\"Korrisoo Oddoo Gubaa\",\"Ejersa Lafoo\",\"4\/4\/2007\",430,50,480],[117,\"Gaarree Kooraa\",\"Ejersa Lafoo\",\"4\/4\/2007\",192,54,246],[118,\"Dagaa Eeguu\",\"Ejersa Lafoo\",\"4\/4\/2007\",276,39,315],[119,\"Awaash Waajituu\",\"Ejersa Lafoo\",\"4\/7\/2009\",467,101,568],[120,\"Waajituu\",\"Ejeree\",\"\",396,59,455],[121,\"Bakkee Boxii\",\"Gindabarat\",\"21\/04\/2008\",507,41,548],[122,\"Dirree Laga Dabal\",\"Gindabarat\",\"26\/12\/2008\",719,39,758],[123,\"Malkaa Qeelloo\",\"Gindabarat\",\"26\/5\/06\",63,47,110],[124,\"Culluxxee\",\"Gindabarat\",\"1997\",1336,312,1648],[125,\"Gooroo Mana Ergaa\",\"Gindabarat\",\"23\/2\/05\",1081,179,1260],[126,\"Gonfii Yabaloo\",\"Gindabarat\",\"29\/1\/2004\",1008,203,1211],[127,\"Goodaa Qunnii\",\"Gindabarat\",\"2006\",738,183,921],[128,\"Mudhii\",\"Gindabarat\",\"10\/3\/2006\",904,204,1108],[129,\"Naannoo Abunii\",\"Gindabarat\",\"26\/5\/2006\",1352,266,1618],[130,\"Naannoo Kaachisii\",\"Gindabarat\",\"29\/1\/2004\",870,355,1225],[131,\"Qarree Doobbii\",\"Gindabarat\",\"29\/1\/2004\",882,218,1100],[132,\"Winee Roggee\",\"Gindabarat\",\"29\/1\/2004\",1348,393,1741],[133,\"Qilxuu Sambataa\",\"Gindabarat\",\"2008\",339,109,448],[134,\"Gammachuu\",\"Iluu Galaan\",\"7\/4\/2007\",469,17,486],[135,\"Guddina Wadeeyyii Giraancee\",\"Iluu Galaan\",\"16\/5\/2008\",880,20,900],[136,\"Raachoo Dirqii\",\"Iluu Galaan\",\"1997\",328,67,395],[137,\"Raffisoo Qaamminoo\",\"Iluu Galaan\",\"3\/4\/2007\",737,15,752],[138,\"Siibaa Biichee\",\"Iluu Galaan\",\"3\/4\/2007\",596,57,653],[139,\"Siree Sillaasee\",\"Iluu Galaan\",\"3\/4\/2005\",276,29,305],[140,\"Baaroo\",\"Iluu Galaan\",\"12\/7\/1996\",878,143,1021],[141,\"Jaatoo Dirqii\",\"Iluu Galaan\",\"24\/1\/1997\",356,80,436],[142,\"Qilxuu Ilaalaa\",\"Iluu Galaan\",\"1995\",641,39,680],[143,\"Sadan Iluu\",\"Iluu Galaan\",\"30\/1\/2004\",803,143,946],[144,\"Guddina Warjii\",\"Iluu Galaan\",\"24\/5\/09\",759,45,804],[145,\"Guddina Walqixxee\",\"Iluu Galaan\",\"2\/4\/2011\",508,35,543],[146,\"Ambaltaa Godeettii\",\"Ilfata\",\"22\/3\/2008\",511,68,579],[147,\"Dhaabaa Madaanaalam\",\"Ilfata\",\"22\/5\/2006\",701,151,852],[148,\"Giccee\",\"Ilfata\",\"22\/3\/2008\",486,75,561],[149,\"Naannoo Gossoo Mikaa'eel\",\"Ilfata\",\"26\/05\/2006\",1084,109,1193],[150,\"Guutee Saadoo\",\"Ilfata\",\"28\/5\/06\",869,69,938],[151,\"Haroo Tuftichaa\",\"Ilfata\",\"23\/4\/06\",1175,266,1441],[152,\"Faallicha\",\"Ilfata\",\"3\/4\/2007\",403,54,457],[153,\"Hidhabuu Sandii\",\"Ilfata\",\"8\/4\/2007\",242,13,255],[154,\"Ittisaa Kooyyee\",\"Ilfata\",\"8\/4\/2007\",465,60,525],[155,\"Jirmaa Korbeessaa\",\"Ilfata\",\"3\/4\/2007\",293,32,325],[156,\"Somboo Cittuu\",\"Ilfata\",\"8\/4\/2007\",405,90,495],[157,\"Saaxoo Lukkuu\",\"Ilfata\",\"4\/4\/2007\",218,54,272],[158,\"Haaruu Sinaanii\",\"Ilfata\",\"5\/5\/2007\",197,68,265],[159,\"Xoosanyi Gafaree\",\"Ilfata\",\"3\/4\/2007\",603,95,698],[160,\"Cillaanqoo\",\"Jalduu\",\"29\/1\/2008\",573,169,742],[161,\"Edensa Galaan\",\"Jalduu\",\"3\/4\/2007\",779,199,978],[162,\"Shukutee\",\"Jalduu\",\"12\/6\/2006\",1489,105,1594],[163,\"Biichoo\",\"Jalduu\",\"1995\",1107,90,1197],[164,\"Bonii\",\"Jalduu\",\"1997\",1418,162,1580],[165,\"Kilbee\",\"Jalduu\",\"1995\",685,101,786],[166,\"Koluu\",\"Jalduu\",\"1997\",986,217,1203],[167,\"Sariitii\",\"Jalduu\",\"1997\",1007,167,1174],[168,\"Tasoo\",\"Jalduu\",\"1996\",879,76,955],[169,\"Urga'aa Eererii\",\"Jalduu\",\"22\/3\/2008\",500,54,554],[170,\"Tulluu Bultumaa\",\"Jalduu\",\"22\/3\/2008\",867,149,1016],[171,\"Tulluu Gurraa\",\"Jalduu\",\"22\/03\/2008\",796,109,905],[172,\"Abbayyii Reejii\",\"Jibaat\",\"15\/5\/2006\",182,21,203],[173,\"Adaammii Ukee\",\"Jibaat\",\"24\/03\/2008\",306,25,331],[174,\"Alii osoo\",\"Jibaat\",\"\",375,42,417],[175,\"Biloo Garbii\",\"Jibaat\",\"24\/6\/2006\",454,33,487],[176,\"Gaamoo Adaadii\",\"Jibaat\",\"28\/5\/2006\",498,51,549],[177,\"Ichaa Dikaa\",\"Jibaat\",\"2001\",433,72,505],[178,\"Kuyyuu Areeree\",\"Jibaat\",\"1998\",450,28,478],[179,\"Kuttaayee Muunyoo\",\"Jibaat\",\"2001\",519,49,568],[180,\"Muunyoo Wiixatee\",\"Jibaat\",\"2001\",554,55,609],[181,\"Maaruu Bahaa\",\"Jibaat\",\"3\/4\/2007\",275,30,305],[182,\"Maaruu Gajjaa\",\"Jibaat\",\"14\/4\/2006\",319,40,359],[183,\"Moluu Faallee\",\"Jibaat\",\"24\/03\/2008\",345,45,390],[184,\"Naannoo Shanan\",\"Jibaat\",\"28\/5\/2006\",665,76,741],[185,\"Dirree Xooxoo\",\"Liiban Jaawwii\",\"7\/4\/2007\",320,41,361],[186,\"Liiban\",\"Liiban Jaawwii\",\"\",1412,255,1667],[187,\"Tokkummaa Liiban\",\"Liiban Jaawwii\",\"28\/5\/06\",137,18,155],[188,\"Alaaltuu fi Dhirikoo\",\"Liiban Jaawwii\",\"24\/03\/2008\",224,24,248],[189,\"Cancaduu fi Masaraa\",\"Liiban Jaawwii\",\"1\/5\/2006\",453,58,511],[190,\"Gaamoo Yabaloo\",\"Liiban Jaawwii\",\"28\/5\/2006\",246,39,285],[191,\"Tulluu Baajoo\",\"Liiban Jaawwii\",\"16\/08\/2010\",363,82,445],[192,\"Agal Gobbuu Basaallee\",\"Liiban Jaawwii\",\"16\/08\/2010\",240,43,283],[193,\"Guddinaaf\",\"Liiban Jaawwii\",\"24\/03\/2008\",697,72,769],[194,\"Muunyoo Kashambal\",\"Liiban Jaawwii\",\"24\/03\/2008\",318,76,394],[195,\"Tokkee Kombolchaa\",\"Liiban Jaawwii\",\"15\/2\/1991\",835,162,997],[196,\"Naannoo Baabboo Gaalloo\",\"Liiban Jaawwii\",\"18\/04\/2006\",1020,197,1217],[197,\"Dirree Buuruu\",\"Midaa Qanyii\",\"22\/03\/2008\",355,11,366],[198,\"Goodaa Bixxillee\",\"Midaa Qanyii\",\"24\/5\/2006\",273,47,320],[199,\"Gambeela\",\"Midaa Qanyii\",\"22\/3\/2008\",75,5,80],[200,\"Goodaa Arbaa\",\"Midaa Qanyii\",\"24\/03\/2008\",223,11,234],[201,\"Tulluu Noonnoo\",\"Midaa Qanyii\",\"24\/5\/2006\",340,10,350],[202,\"Waayyuu Inkee\",\"Midaa Qanyii\",\"24\/03\/2008\",140,5,145],[203,\"Baaroo Bidaaruu\",\"Midaa Qanyii\",\"24\/5\/2006\",377,65,442],[204,\"Cuqqaalaa Wangee\",\"Midaa Qanyii\",\"2001\",637,23,660],[205,\"Dirree Lalisaa\",\"Midaa Qanyii\",\"2001\",425,45,470],[206,\"Goosuu Gonjii\",\"Midaa Qanyii\",\"2001\",644,62,706],[207,\"Galaan Gumjee\",\"Midaa Qanyii\",\"24\/5\/2006\",235,25,260],[208,\"Km\/Haroo Dirree Gadaa\",\"Midaa Qanyii\",\"24\/3\/2006\",300,41,341],[209,\"Harbuu Koobii\",\"Midaa Qanyii\",\"8\/4\/2007\",251,30,281],[210,\"Qanyii Gabreel\",\"Midaa Qanyii\",\"1997\",684,45,729],[211,\"Tulluu Lammii\",\"Midaa Qanyii\",\"\",93,4,97],[212,\"Waloo Taambaroo\",\"Midaa Qanyii\",\"18\/08\/2010\",191,62,253],[213,\"Biloo Waayyuu\",\"Noonnoo\",\"30\/1\/2007\",420,120,540],[214,\"Bakkee Mootii\",\"Noonnoo\",\"30\/1\/2007\",407,35,442],[215,\"Dikkoo Shuummoo\",\"Noonnoo\",\"30\/1\/2007\",386,100,486],[216,\"Hiilloo\",\"Noonnoo\",\"30\/1\/2007\",400,50,450],[217,\"Naannoo Qondaalaa\",\"Noonnoo\",\"27\/05\/2006\",422,23,445],[218,\"Biloo Meettaa\",\"Noonnoo\",\"24\/3\/2008\",350,66,416],[219,\"Burqaa Guddinaa\",\"Noonnoo\",\"22\/03\/2008\",567,56,623],[220,\"Caandoo\",\"Noonnoo\",\"22\/03\/2008\",397,55,452],[221,\"Caffee Odaa\",\"Noonnoo\",\"22\/03\/2008\",382,55,437],[222,\"Godaannoo\",\"Noonnoo\",\"22\/03\/2008\",350,30,380],[223,\"Hurrumuu Qorkee\",\"Noonnoo\",\"24\/03\/2005\",312,30,342],[224,\"Naannoo Halloo\",\"Noonnoo\",\"1998\",310,43,353],[225,\"Qonnooree Hurrumuu\",\"Noonnoo\",\"28\/5\/2007\",332,60,392],[226,\"Taltallee fi Beerree\",\"Noonnoo\",\"22\/03\/2008\",444,53,497],[227,\"Mattuu siillaasee\",\"Noonnoo\",\"26\/05\/2009\",687,34,721],[228,\"Qorkee Maariyaam\",\"Noonnoo\",\"29\/03\/2008\",323,30,353],[229,\"Hurrumuu Gabreel\",\"Noonnoo\",\"15\/4\/2011\",405,52,457],[230,\"Dambii\",\"Noonnoo\",\"24\/3\/2008\",354,43,397],[231,\"Tokkee Arfinjoo\",\"Tokkee Kuttaayee\",\"24\/03\/2008\",307,34,341],[232,\"Mutuluu\",\"Tokkee Kuttaayee\",\"15\/2\/1991\",1783,136,1919],[233,\"Qilinxoo\",\"Tokkee Kuttaayee\",\"1994\",1474,568,2042],[234,\"Tokkee Gabaa Kamisaa\",\"Tokkee Kuttaayee\",\"15\/2\/1991\",1391,95,1486],[235,\"Tokkee Gooroo Soolee\",\"Tokkee Kuttaayee\",\"2000\",1195,143,1338],[236,\"Tokkee Irreensaa\",\"Tokkee Kuttaayee\",\"15\/2\/1991\",1043,65,1108],[237,\"Naannoo Wajiiraa\",\"Tokkee Kuttaayee\",\"1997\",589,22,611],[238,\"Guddina Laaluu\",\"Tokkee Kuttaayee\",\"25\/07\/09\",60,1,61],[239,\"Hadharsaa Biilaa\",\"Tokkee Kuttaayee\",\"2010\",190,16,206],[240,\"Hundee Guddinaa\",\"Tokkee Kuttaayee\",\"2004\",463,158,621],[241,\"Daadaa Galaan\",\"Tokkee Kuttaayee\",\"2004\",614,141,755],[242,\"Malkaa Nagaa Dambii\",\"Tokkee Kuttaayee\",\"2004\",614,141,755],[243,\"G\/O\/Q Kolbaa\",\"Tokkee Kuttaayee\",\"2004\",418,38,456],[244,\"Oolee Sillaasee\",\"Tokkee Kuttaayee\",\"2004\",220,55,275],[245,\"Fincaa'aa Malkee\",\"Tokkee Kuttaayee\",\"2004\",459,138,597],[246,\"Tulluu\",\"Tokkee Kuttaayee\",\"2004\",224,27,251],[247,\"Badhaasaa\",\"Tokkee Kuttaayee\",\"2004\",463,158,621],[248,\"Baddeessaa Dambii\",\"Ab\/ Gindabarat\",\"23\/3\/2012\",117,1,118],[249,\"Gobbaa Waashamoo\",\"Iluu Galaan\",\"23\/3\/2012\",236,20,256],[250,\"Haroo Dhagaa Dhaabaa\",\"Jalduu\",\"23\/3\/2012\",1136,90,1226],[251,\"Gaamoo Jibaat\",\"Jibaat\",\"23\/3\/2012\",191,25,216],[252,\"Gaamoo Walisoo\",\"Liiban Jaawwii\",\"23\/3\/2012\",195,17,212],[253,\"Irreensa Baadiyyaa\",\"Liiban Jaawwii\",\"23\/3\/2012\",305,54,359],[254,\"Alii Abbo Saree\",\"Noonnoo\",\"4\/4\/2012\",372,53,425],[255,\"Mattuu Silmii\",\"Noonnoo\",\"15\/4\/2011\",385,85,470],[256,\"Alii Narvoo\",\"Noonnoo\",\"29\/3\/2011\",302,40,342],[257,\"Alii Alakaasee\",\"Noonnoo\",\"2\/4\/2011\",358,28,386],[258,\"Abbayyii Heebanii\",\"Noonnoo\",\"6\/4\/2013\",400,76,476],[259,\"Ancabbii Baddeessoo\",\"Daannoo\",\"6\/4\/2013\",351,16,367],[260,\"Caancoo Qabbanaa'aa\",\"Jalduu\",\"7\/7\/2013\",517,98,615],[261,\"Galmoo Warabboo\",\"Noonnoo\",\"6\/4\/2013\",403,39,442],[262,\"Hullugeetaa Karrayyuu\",\"Noonnoo\",\"6\/4\/2013\",322,37,359],[263,\"Hurrumuu Jibaat\",\"Noonnoo\",\"6\/4\/2013\",312,30,342],[264,\"Intoo Daallee\",\"Jalduu\",\"20\/05\/2013\",366,61,427],[265,\"Meettaa Warjii\",\"Iluu Galaan\",\"6\/4\/2013\",759,45,804],[266,\"Halloo Dinkii\",\"Noonnoo\",\"5\/4\/2014\",401,65,466],[267,\"Biiftuu Jaalalaa\",\"Noonnoo\",\"5\/4\/2014\",550,120,670],[268,\"Jiruu Gammachuu\",\"Noonnoo\",\"5\/4\/2014\",948,47,995],[269,\"G\/ Haleeluu Odaa Guutaa\",\"Calliyaa\",\"5\/4\/2014\",284,40,324],[270,\"Coomee Mana Ergaa\",\"Gindabarat\",\"5\/4\/2014\",265,157,422],[271,\"Muka Diimaa\",\"Gindabarat\",\"5\/4\/2014\",993,491,1484],[272,\"Tokkummaa Burqaa Guddinaa\",\"Bul. BM Amboo\",\"23\/4\/2015\",147,50,197],[273,\"Badhaastuu\",\"Dirree Incinnii\",\"22\/04\/2015\",21,5,26],[274,\"Gololee\",\"Noonnoo\",\"15\/06\/2015\",450,100,550],[275,\"Biloo Aabboo\",\"Noonnoo\",\"2\/5\/2016\",312,30,342],[276,\"Naannoo Sanqallee\",\"Bul. BM Amboo\",\"26\/04\/2018\",610,358,968],[277,\"Guddina Jijjiguu\",\"Amboo\",\"26\/04\/2018\",81,1,82],[278,\"Bagaalloo Gabbisaa\",\"Amboo\",\"26\/04\/2018\",108,0,108],[279,\"Tulluu Gurjii\",\"Jalduu\",\"26\/04\/2018\",92,6,98],[280,\"Guddina Oborraa\",\"Iluu Galaan\",\"26\/04\/2018\",399,60,459],[281,\"Mixaarii Heebanii\",\"Noonnoo\",\"26\/04\/2018\",139,17,156],[282,\"Imbooroo\",\"Noonnoo\",\"26\/04\/2018\",524,36,560],[283,\"Naannoo Goljaa\",\"Amboo\",\"26\/04\/2018\",625,25,650],[284,\"Obbee Kuraa\",\"Midaa Qanyii\",\"26\/04\/2018\",350,54,404]\n ];\n\n let globalData = [...cooperativesData];\n let currentDisplayData = [...globalData];\n let coopChart, memberChart;\n\n function aggregateWoreda(data) {\n const map = new Map();\n data.forEach(row => {\n let w = row[2].trim();\n if (!map.has(w)) map.set(w, { count: 0, totalMembers: 0 });\n let val = map.get(w);\n val.count++;\n val.totalMembers += row[6];\n });\n return map;\n }\n\n function updateChartsAndTotals(data) {\n const agg = aggregateWoreda(data);\n const woredas = Array.from(agg.keys()).sort();\n const coopCounts = woredas.map(w => agg.get(w).count);\n const memberTotals = woredas.map(w => agg.get(w).totalMembers);\n \n document.getElementById('totalWoredasCount').innerText = woredas.length;\n \n if (coopChart) coopChart.destroy();\n if (memberChart) memberChart.destroy();\n \n const ctx1 = document.getElementById('coopWoredaChart').getContext('2d');\n coopChart = new Chart(ctx1, {\n type: 'bar',\n data: { labels: woredas, datasets: [{ label: 'Number of coops', data: coopCounts, backgroundColor: '#e6b13e', borderRadius: 8 }] },\n options: { responsive: true, maintainAspectRatio: false, plugins: { legend: { display: false } }, scales: { y: { beginAtZero: true, ticks: { stepSize: 1 } } } }\n });\n \n const ctx2 = document.getElementById('membersWoredaChart').getContext('2d');\n memberChart = new Chart(ctx2, {\n type: 'bar',\n data: { labels: woredas, datasets: [{ label: 'Total members', data: memberTotals, backgroundColor: '#2c8c3e', borderRadius: 8 }] },\n options: { responsive: true, maintainAspectRatio: false, plugins: { legend: { display: false } }, scales: { y: { beginAtZero: true } } }\n });\n \n \/\/ totals summary\n let totalMale = 0, totalFemale = 0, totalMembers = 0;\n data.forEach(r => { totalMale += r[4]; totalFemale += r[5]; totalMembers += r[6]; });\n document.getElementById('totalMaleSpan').innerText = totalMale.toLocaleString();\n document.getElementById('totalFemaleSpan').innerText = totalFemale.toLocaleString();\n document.getElementById('totalMembersSum').innerText = totalMembers.toLocaleString();\n document.getElementById('rowCountDisplay').innerHTML = data.length + ' entries';\n }\n\n function renderTable(data) {\n const tbody = document.getElementById('tableBody');\n tbody.innerHTML = '';\n data.forEach(row => {\n const tr = document.createElement('tr');\n tr.innerHTML = `\n <td>${row[0]}<\/td>\n <td>${escapeHtml(row[1])}<\/td>\n <td>${escapeHtml(row[2])}<\/td>\n <td>${row[3] || '\u2014'}<\/td>\n <td>${row[4].toLocaleString()}<\/td>\n <td>${row[5].toLocaleString()}<\/td>\n <td>${row[6].toLocaleString()}<\/td>\n `;\n tbody.appendChild(tr);\n });\n updateChartsAndTotals(data);\n currentDisplayData = data;\n }\n \n function escapeHtml(str) { return String(str).replace(\/[&<>]\/g, function(m){ if(m === '&') return '&'; if(m === '<') return '<'; if(m === '>') return '>'; return m;}); }\n \n function filterTable() {\n const query = document.getElementById('searchInput').value.toLowerCase();\n const filtered = globalData.filter(row => \n row[1].toLowerCase().includes(query) || \n row[2].toLowerCase().includes(query) || \n (row[3] && row[3].toLowerCase().includes(query))\n );\n renderTable(filtered);\n }\n \n function exportToExcel(type) {\n const dataToExport = (type === 'all') ? globalData : currentDisplayData;\n const sheetData = [['SN', 'Cooperative Name', 'Woreda', 'Membership Date', 'Male', 'Female', 'Total Members'],\n ...dataToExport.map(r => [r[0], r[1], r[2], r[3] || '', r[4], r[5], r[6]])];\n const wb = XLSX.utils.book_new();\n const ws = XLSX.utils.aoa_to_sheet(sheetData);\n XLSX.utils.book_append_sheet(wb, ws, 'AFCU_Cooperatives');\n XLSX.writeFile(wb, `afcu_cooperatives_${type}_${new Date().toISOString().slice(0,10)}.xlsx`);\n }\n \n document.getElementById('searchInput').addEventListener('keyup', filterTable);\n document.getElementById('exportAllBtn').onclick = () => exportToExcel('all');\n document.getElementById('exportFilteredBtn').onclick = () => exportToExcel('filtered');\n \n renderTable(globalData);\n<\/script>\n<\/body>\n<\/html>\n","protected":false},"excerpt":{"rendered":"<p>AFCU \u00b7 West Shewa Analytics \u00b7 284 Primary Cooperatives Ambo Farmers’ Cooperative Union LTD est. 1998 www.afcu.org.et \u00b7 official cooperative data West Shewa \u00b7 284 coops \u2014 Woredas 284 Primary Coops \u2014 Total Members Male members: 0 Female members: 0 Woreda-wise aggregation \u00b7 284 cooperatives from official registry Cooperatives per Woreda Total Members per Woreda…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"fullwidth","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-235","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/posts\/235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afcu.org.et\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=235"}],"version-history":[{"count":14,"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions"}],"predecessor-version":[{"id":1133,"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions\/1133"}],"wp:attachment":[{"href":"https:\/\/afcu.org.et\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afcu.org.et\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afcu.org.et\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":235,"date":"2026-03-18T07:12:00","date_gmt":"2026-03-18T07:12:00","guid":{"rendered":"https:\/\/afcu.org.et\/?p=235"},"modified":"2026-03-28T16:40:17","modified_gmt":"2026-03-28T16:40:17","slug":"financial-status-of-afcu","status":"publish","type":"post","link":"https:\/\/afcu.org.et\/?p=235","title":{"rendered":"Cooperatives Information"},"content":{"rendered":"\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n\n\n\n \n \n AFCU \u00b7 West Shewa Analytics \u00b7 284 Primary Cooperatives<\/title>\n \n <link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/6.0.0-beta3\/css\/all.min.css\">\n <link href=\"https:\/\/fonts.googleapis.com\/css2?family=Inter:opsz,wght@14..32,400;14..32,500;14..32,600;14..32,700;14..32,800&display=swap\" rel=\"stylesheet\">\n \n <script src=\"https:\/\/cdn.jsdelivr.net\/npm\/chart.js@4.4.0\/dist\/chart.umd.min.js\"><\/script>\n \n <script src=\"https:\/\/cdn.sheetjs.com\/xlsx-0.20.2\/package\/dist\/xlsx.full.min.js\"><\/script>\n <style>\n * {\n margin: 0;\n padding: 0;\n box-sizing: border-box;\n }\n\n body {\n background: linear-gradient(145deg, #e9ddbb 0%, #d2bf8a 100%);\n font-family: 'Inter', sans-serif;\n padding: 24px 20px;\n min-height: 100vh;\n }\n\n .dashboard-container {\n max-width: 1600px;\n margin: 0 auto;\n background: rgba(255, 252, 240, 0.96);\n backdrop-filter: blur(2px);\n border-radius: 52px;\n box-shadow: 0 30px 45px -18px rgba(0,0,0,0.4);\n border: 2px solid rgba(218, 165, 32, 0.6);\n padding: 2rem 2rem 1.8rem;\n }\n\n \/* Header with official branding *\/\n .hero-header {\n display: flex;\n align-items: center;\n justify-content: space-between;\n flex-wrap: wrap;\n gap: 20px;\n margin-bottom: 28px;\n padding-bottom: 18px;\n border-bottom: 3px solid #e8b13e;\n }\n\n .brand-logo-area {\n display: flex;\n align-items: center;\n gap: 18px;\n background: #fdf5e2;\n border-radius: 90px;\n padding-right: 32px;\n border: 1px solid #daa520;\n }\n\n .logo-circle {\n width: 80px;\n height: 80px;\n background: #fff2df;\n border-radius: 50%;\n display: flex;\n align-items: center;\n justify-content: center;\n border: 3px solid #b67d1b;\n box-shadow: 0 6px 14px rgba(0,0,0,0.1);\n }\n .logo-circle i { font-size: 44px; color: #b6461c; }\n\n .union-text h1 {\n font-size: 1.8rem;\n font-weight: 800;\n color: #952e1a;\n letter-spacing: -0.3px;\n }\n .union-text p { font-size: 0.8rem; color: #b67d1b; font-weight: 600; }\n\n .stats-chip-badge {\n background: #237a33;\n padding: 10px 28px;\n border-radius: 40px;\n color: #ffeaad;\n font-weight: 800;\n font-size: 1.1rem;\n }\n\n \/* summary panel *\/\n .summary-panel {\n background: #f3ecda;\n border-radius: 40px;\n padding: 1.5rem 2rem;\n margin: 1.5rem 0 2rem;\n border: 2px solid #dba642;\n box-shadow: inset 0 1px 6px #fff6e6, 0 12px 18px -12px #7f6130;\n }\n\n .kpi-row {\n display: flex;\n justify-content: space-between;\n flex-wrap: wrap;\n gap: 18px;\n margin-bottom: 20px;\n }\n .kpi-card {\n background: white;\n border-radius: 32px;\n padding: 1rem 2rem;\n min-width: 160px;\n text-align: center;\n box-shadow: 0 4px 12px rgba(0,0,0,0.05);\n border-left: 6px solid #daa520;\n }\n .kpi-number { font-size: 2rem; font-weight: 800; color: #1c6b2b; }\n\n .gender-badges {\n display: flex;\n gap: 24px;\n flex-wrap: wrap;\n margin: 15px 0 12px;\n }\n .male-badge { background: #2c7a3b; padding: 8px 24px; border-radius: 40px; color: white; font-weight: 700; }\n .female-badge { background: #c47d2e; padding: 8px 24px; border-radius: 40px; color: white; font-weight: 700; }\n\n \/* charts grid *\/\n .charts-grid {\n display: flex;\n flex-wrap: wrap;\n gap: 28px;\n margin: 2rem 0 2.2rem;\n }\n .chart-box {\n flex: 1 1 420px;\n background: #fffef5;\n border-radius: 36px;\n padding: 1.4rem 1.6rem;\n border: 2px solid #e6b550;\n box-shadow: 0 10px 18px -8px #b68b40;\n }\n .chart-box h3 {\n font-size: 1.4rem;\n margin-bottom: 1rem;\n color: #2c6e2c;\n display: flex;\n align-items: center;\n gap: 10px;\n border-bottom: 2px solid #f3c26b;\n padding-bottom: 10px;\n }\n .chart-canvas-container { position: relative; height: 300px; width: 100%; }\n\n \/* action bar *\/\n .action-bar {\n display: flex;\n flex-wrap: wrap;\n gap: 16px;\n margin: 1.5rem 0 1.8rem;\n align-items: center;\n }\n .btn {\n padding: 12px 28px;\n border-radius: 60px;\n font-weight: 700;\n border: none;\n cursor: pointer;\n font-size: 0.95rem;\n display: inline-flex;\n align-items: center;\n gap: 10px;\n transition: 0.2s;\n }\n .btn-excel { background: #1f6e3a; color: white; }\n .btn-excel:hover { background: #2b8a48; }\n .btn-filtered { background: #c47d2e; color: white; }\n .stats-badge-light { background: #2c5f2d; color: #ffefb9; padding: 10px 24px; border-radius: 60px; font-weight: 600; }\n\n .search-wrapper { margin: 1rem 0 1.5rem; }\n .search-wrapper input {\n width: 100%;\n padding: 16px 24px;\n border-radius: 60px;\n border: 2px solid #e2b551;\n font-size: 1rem;\n outline: none;\n background: white;\n }\n\n .table-responsive {\n overflow-x: auto;\n border-radius: 32px;\n background: #fff9ec;\n padding: 1rem;\n border: 2px solid #e8bc6e;\n margin: 1.8rem 0;\n }\n .coop-table {\n width: 100%;\n border-collapse: collapse;\n font-size: 0.85rem;\n }\n .coop-table th {\n background: #2a592a;\n color: #fcd34d;\n padding: 14px 8px;\n font-weight: 600;\n white-space: nowrap;\n }\n .coop-table td {\n padding: 10px 6px;\n border-bottom: 1px solid #eedbaf;\n color: #2f4d2f;\n }\n .coop-table tr:hover { background: #f9efda; }\n\n .footer-links {\n background: #1f5420;\n border-radius: 48px;\n padding: 2rem 2rem 1.5rem;\n margin-top: 2rem;\n color: #fef0cf;\n border-top: 4px solid #f3bc4b;\n }\n .footer-grid {\n display: flex;\n flex-wrap: wrap;\n gap: 2.5rem;\n justify-content: space-between;\n }\n .footer-col h4 {\n font-size: 1.2rem;\n border-left: 4px solid #f5bc42;\n padding-left: 12px;\n margin-bottom: 1rem;\n }\n .footer-col ul { list-style: none; }\n .footer-col li { margin: 10px 0; }\n .footer-col a {\n color: #ffefc4;\n text-decoration: none;\n display: flex;\n align-items: center;\n gap: 10px;\n font-size: 0.9rem;\n }\n .copyright {\n text-align: center;\n margin-top: 2rem;\n padding-top: 1.5rem;\n border-top: 1px dashed #f3bc42;\n font-size: 0.85rem;\n }\n .west-banner {\n background: #fac56430;\n text-align: center;\n padding: 8px;\n border-radius: 60px;\n font-weight: 600;\n margin: 12px 0 0;\n }\n @media (max-width: 700px) {\n .dashboard-container { padding: 1.2rem; }\n .kpi-card { padding: 0.6rem 1rem; min-width: 120px; }\n }\n <\/style>\n<\/head>\n<body>\n<div class=\"dashboard-container\">\n \n <div class=\"hero-header\">\n <div class=\"brand-logo-area\">\n <div class=\"logo-circle\">\n <i class=\"fas fa-tractor\"><\/i>\n <\/div>\n <div class=\"union-text\">\n <h1>Ambo Farmers’ Cooperative Union LTD <span style=\"font-size:0.9rem;\">est. 1998<\/span><\/h1>\n <p><i class=\"fas fa-globe-africa\"><\/i> www.afcu.org.et \u00b7 official cooperative data<\/p>\n <\/div>\n <\/div>\n <div class=\"stats-chip-badge\">\n <i class=\"fas fa-chart-line\"><\/i> West Shewa \u00b7 284 coops\n <\/div>\n <\/div>\n\n \n <div class=\"summary-panel\" id=\"summaryPanel\">\n <div class=\"kpi-row\">\n <div class=\"kpi-card\"><i class=\"fas fa-city\"><\/i> <div class=\"kpi-number\" id=\"totalWoredasCount\">\u2014<\/div><span>Woredas<\/span><\/div>\n <div class=\"kpi-card\"><i class=\"fas fa-handshake\"><\/i> <div class=\"kpi-number\">284<\/div><span>Primary Coops<\/span><\/div>\n <div class=\"kpi-card\"><i class=\"fas fa-chart-simple\"><\/i> <div class=\"kpi-number\" id=\"totalMembersSum\">\u2014<\/div><span>Total Members<\/span><\/div>\n <\/div>\n <div class=\"gender-badges\">\n <span class=\"male-badge\"><i class=\"fas fa-mars\"><\/i> Male members: <span id=\"totalMaleSpan\">0<\/span><\/span>\n <span class=\"female-badge\"><i class=\"fas fa-venus\"><\/i> Female members: <span id=\"totalFemaleSpan\">0<\/span><\/span>\n <\/div>\n <div class=\"west-banner\">\n <i class=\"fas fa-chart-pie\"><\/i> Woreda-wise aggregation \u00b7 284 cooperatives from official registry\n <\/div>\n <\/div>\n\n \n <div class=\"charts-grid\">\n <div class=\"chart-box\">\n <h3><i class=\"fas fa-chart-bar\"><\/i> Cooperatives per Woreda<\/h3>\n <div class=\"chart-canvas-container\">\n <canvas id=\"coopWoredaChart\"><\/canvas>\n <\/div>\n <\/div>\n <div class=\"chart-box\">\n <h3><i class=\"fas fa-users\"><\/i> Total Members per Woreda<\/h3>\n <div class=\"chart-canvas-container\">\n <canvas id=\"membersWoredaChart\"><\/canvas>\n <\/div>\n <\/div>\n <\/div>\n\n \n <div class=\"action-bar\">\n <button class=\"btn btn-excel\" id=\"exportAllBtn\"><i class=\"fas fa-file-excel\"><\/i> Export all (Excel)<\/button>\n <button class=\"btn btn-filtered\" id=\"exportFilteredBtn\"><i class=\"fas fa-filter\"><\/i> Export filtered<\/button>\n <div class=\"stats-badge-light\" id=\"rowCountDisplay\">284 entries<\/div>\n <\/div>\n\n <div class=\"search-wrapper\">\n <input type=\"text\" id=\"searchInput\" placeholder=\"🔍 Search by cooperative name, woreda, or membership date...\" autocomplete=\"off\">\n <\/div>\n\n \n <div class=\"table-responsive\">\n <table class=\"coop-table\" id=\"coopTable\">\n <thead>\n <tr><th>#<\/th><th>Cooperative Name<\/th><th>Woreda<\/th><th>Membership Date<\/th><th>Male<\/th><th>Female<\/th><th>Total Members<\/th><\/tr>\n <\/thead>\n <tbody id=\"tableBody\"><\/tbody>\n <\/table>\n <\/div>\n\n \n <div class=\"footer-links\">\n <div class=\"footer-grid\">\n <div class=\"footer-col\">\n <h4><i class=\"fas fa-seedling\"><\/i> AFCU Services<\/h4>\n <ul>\n <li><a href=\"https:\/\/www.afcu.org.et\/?page_id=26\" target=\"_blank\"><i class=\"fas fa-tractor\"><\/i> Mechanization<\/a><\/li>\n <li><a href=\"https:\/\/www.afcu.org.et\/?page_id=27\" target=\"_blank\"><i class=\"fas fa-truck\"><\/i> Input supply<\/a><\/li>\n <li><a href=\"https:\/\/www.afcu.org.et\/?page_id=29\" target=\"_blank\"><i class=\"fas fa-egg\"><\/i> Dairy farming<\/a><\/li>\n <\/ul>\n <\/div>\n <div class=\"footer-col\">\n <h4><i class=\"fas fa-info-circle\"><\/i> About Union<\/h4>\n <ul>\n <li><a href=\"https:\/\/www.afcu.org.et\/?page_id=11\" target=\"_blank\"><i class=\"fas fa-history\"><\/i> Background<\/a><\/li>\n <li><a href=\"https:\/\/www.afcu.org.et\/?page_id=9\" target=\"_blank\"><i class=\"fas fa-bullseye\"><\/i> Mission<\/a><\/li>\n <\/ul>\n <\/div>\n <\/div>\n <div class=\"copyright\">\n <i class=\"fas fa-copyright\"><\/i> 2025 Ambo Farmers Cooperative Union \u2013 Official Data Portal | www.afcu.org.et\n <\/div>\n <\/div>\n<\/div>\n\n<script>\n \/\/ --------------------------------------------------------------\n \/\/ COMPLETE DATASET (284 entries) based on provided table\n \/\/ Each entry: [SN, CoopName, Woreda, Date, Male, Female, Total]\n \/\/ --------------------------------------------------------------\n const cooperativesData = [\n [1,\"Anfaara Hoolotoo\",\"Gindabarat\",\"22\/3\/2008\",108,36,144],[2,\"Badda-Xinnoo\",\"Gindabarat\",\"24\/3\/2008\",100,2,102],[3,\"Badeessa Caandoo\",\"Gindabarat\",\"16\/3\/2008\",67,13,80],[4,\"Bakkee Qalaaxee\",\"Gindabarat\",\"22\/3\/2008\",126,15,141],[5,\"Guutoo Somboo\",\"Gindabarat\",\"24\/3\/2008\",123,20,143],[6,\"Dabaqqaa\",\"Gindabarat\",\"26\/5\/2006\",78,8,86],[7,\"Ererii Keenjoo\",\"Gindabarat\",\"8\/4\/2007\",64,1,65],[8,\"Garbii Goolee\",\"Gindabarat\",\"6\/4\/2007\",44,15,59],[9,\"Gaajoo Baddeessaa\",\"Gindabarat\",\"1\/7\/2007\",120,15,135],[10,\"Gooroo Dhoqonuu\",\"Gindabarat\",\"10\/4\/2007\",53,1,54],[11,\"Insilaalee Gaajoo\",\"Gindabarat\",\"8\/4\/2007\",64,19,83],[12,\"Mandiidaa Xunjiitii\",\"Gindabarat\",\"8\/4\/2007\",150,24,174],[13,\"Naannoo Giixiree\",\"Gindabarat\",\"8\/4\/2007\",151,15,166],[14,\"Ogobee Gaajoo\",\"Gindabarat\",\"8\/4\/2007\",49,3,52],[15,\"Waleensuu\",\"Gindabarat\",\"8\/4\/2007\",64,19,83],[16,\"Willoo Jaganfoo\",\"Gindabarat\",\"8\/4\/2007\",72,4,76],[17,\"Qarree Biitee\",\"Gindabarat\",\"26\/5\/2006\",40,25,65],[18,\"Qarree Ceekaa\",\"Gindabarat\",\"26\/5\/2006\",130,5,135],[19,\"Somboo Walisoo\",\"Gindabarat\",\"29\/1\/2004\",77,26,103],[20,\"Daannisaa Ulaa Burkii\",\"Gindabarat\",\"22\/3\/2002\",58,11,69],[21,\"Doggoma Kibbii\",\"Gindabarat\",\"26\/5\/2006\",45,0,45],[22,\"Doggomaa Yaagot\",\"Gindabarat\",\"26\/5\/2006\",37,0,37],[23,\"Ganda Gooroo Jaalatee\",\"Gindabarat\",\"26\/5\/2006\",118,5,123],[24,\"Guutee Andoodee\",\"Gindabarat\",\"26\/5\/2006\",120,5,125],[25,\"Oborraa\",\"Gindabarat\",\"26\/5\/2006\",93,4,97],[26,\"Haroo\",\"Gindabarat\",\"29\/1\/2004\",336,22,358],[27,\"Jammoo\",\"Gindabarat\",\"29\/1\/2004\",259,6,265],[28,\"Naannoo Gorgisii\",\"Gindabarat\",\"25\/2\/2002\",151,12,163],[29,\"Altufaa\",\"Amboo\",\"7\/4\/2007\",462,74,536],[30,\"Daandii Guddinaa\",\"Amboo\",\"2004\",109,78,187],[31,\"Awwaaroo\",\"Amboo\",\"21\/7\/1997\",657,63,720],[32,\"Biiftuu\",\"Amboo\",\"7\/4\/2007\",235,20,255],[33,\"Naannoo Goromtii\",\"Amboo\",\"8\/4\/2007\",334,69,403],[34,\"Kaarraa\",\"Amboo\",\"22\/03\/2008\",197,13,210],[35,\"Meexxii\",\"Amboo\",\"15\/02\/1991\",1128,296,1424],[36,\"Guddina Taltallee Gobaa Qilxuu\",\"Amboo\",\"10\/4\/2007\",492,109,601],[37,\"Utubaa Jireenyaa\",\"Amboo\",\"26\/05\/2006\",339,399,738],[38,\"Waliin Kaanaa Ganjii Gooroo Horee\",\"Amboo\",\"10\/4\/2007\",292,101,393],[39,\"Guddina Ilaamuu Muujjaa\",\"Amboo\",\"25\/08\/09\",505,128,633],[40,\"Waliin Guddannaa\/Goosuu\",\"Amboo\",\"2004\",89,70,159],[41,\"Walqixxee\/Biloo\",\"Amboo\",\"2004\",445,110,555],[42,\"Biqiltuu\/Abuu Gabbisaa\",\"Amboo\",\"2003\",246,58,304],[43,\"Dassee Akliiloo\",\"Amboo\",\"25\/3\/2011\",207,34,241],[44,\"Tokkummaa\/qibaa qubee\",\"Amboo\",\"2004\",122,68,190],[45,\"Agaloo Sooyyamaa\",\"Calliyaa\",\"7\/4\/2007\",426,58,484],[46,\"Cobii Daalattii\",\"Calliyaa\",\"2002\",1600,301,1901],[47,\"Haroo Hindee\",\"Calliyaa\",\"7\/4\/2007\",378,73,451],[48,\"Hoolee Siree\",\"Calliyaa\",\"7\/4\/2007\",370,23,393],[49,\"Jireenyaa\",\"Calliyaa\",\"7\/4\/2007\",358,37,395],[50,\"Raffisoo Alangaa\",\"Calliyaa\",\"9\/12\/2006\",350,230,580],[51,\"Tulluu Kosorruu\",\"Calliyaa\",\"2002\",1175,190,1365],[52,\"Abdii boruu\",\"Calliyaa\",\"7\/4\/2007\",375,49,424],[53,\"Walii Galtee Jaarsoo\",\"Calliyaa\",\"30\/08\/2010\",910,85,995],[54,\"Hundee Allee\",\"Calliyaa\",\"10\/9\/2010\",371,96,467],[55,\"Cobii Sirbaa\",\"Cobii\",\"26\/4\/2006\",1040,100,1140],[56,\"Qoricha Kootichaa\",\"Cobii\",\"8\/4\/2008\",484,41,525],[57,\"Baakkee oofuu\",\"Cobii\",\"24\/06\/09\",478,192,670],[58,\"Bolaa Dammaqaa\",\"Dirree Incinnii\",\"22\/3\/2008\",90,5,95],[59,\"Buyyaamaa Dabballee\",\"Dirree Incinnii\",\"30\/1\/2004\",239,15,254],[60,\"Gaamoo Gamballaa\",\"Dirree Incinnii\",\"3\/7\/2007\",87,4,91],[61,\"Naannoo Jidduu\",\"Dirree Incinnii\",\"24\/3\/2008\",39,2,41],[62,\"Ajoo Qarsaa Biilii\",\"Dirree Incinnii\",\"24\/3\/2008\",85,5,90],[63,\"Roggee Dagaa\",\"Dirree Incinnii\",\"22\/3\/2008\",94,7,101],[64,\"Abdii Boruu\",\"Dirree Incinnii\",\"4\/4\/2007\",64,3,67],[65,\"Arifinjoo Dagaa\",\"Dirree Incinnii\",\"4\/4\/2007\",81,3,84],[66,\"Bolaa Kalacii\",\"Dirree Incinnii\",\"2006\",132,8,140],[67,\"Buuyyamaa Qochoree\",\"Dirree Incinnii\",\"1997\",220,17,237],[68,\"Biloo Abbayyii\",\"Dirree Incinnii\",\"3\/4\/2007\",115,5,120],[69,\"Buuyyamaa Mijuu\",\"Dirree Incinnii\",\"30\/4\/2007\",138,14,152],[70,\"Naannoo Incinnii\",\"Dirree Incinnii\",\"1997\",1127,47,1174],[71,\"Tokkee Cittuu\",\"Dirree Incinnii\",\"1997\",375,100,475],[72,\"Waldoo Hindhee\",\"Dirree Incinnii\",\"27\/5\/2006\",108,8,116],[73,\"Asgorii\",\"Dandii\",\"\",1450,152,1602],[74,\"Borooddoo Laga Baatuu\",\"Dandii\",\"21\/7\/1997\",1372,280,1652],[75,\"Boddaa\",\"Dandii\",\"21\/7\/1997\",1361,169,1530],[76,\"Diimtuu Baballii\",\"Dandii\",\"2001\",401,68,469],[77,\"Faajjii Booralee\",\"Dandii\",\"30\/1\/2004\",623,131,754],[78,\"Qabaa Bareedaa\",\"Dandii\",\"21\/7\/1997\",668,50,718],[79,\"Waamuraa Meexxii\",\"Dandii\",\"21\/7\/1997\",809,78,887],[80,\"Awaash Boolee\",\"Dandii\",\"4\/4\/2007\",132,17,149],[81,\"Bajiroo\",\"Dandii\",\"23\/5\/2006\",529,103,632],[82,\"Gooroo Sokorruu\",\"Dandii\",\"4\/4\/2007\",401,21,422],[83,\"Gaarree Areeraa\",\"Dandii\",\"2006\",215,33,248],[84,\"Gaattiroo Laaftoo\",\"Dandii\",\"4\/4\/2007\",146,77,223],[85,\"Honcee Biitee\",\"Dandii\",\"22\/3\/2008\",250,125,375],[86,\"Katkata Warra Bulchii\",\"Dandii\",\"4\/4\/2007\",251,50,301],[87,\"Loqloqaa Abbaa\",\"Dandii\",\"23\/5\/2006\",241,104,345],[88,\"Sandaafaa Naannoo Warqaa\",\"Dandii\",\"4\/4\/2007\",251,44,295],[89,\"Xiraangee shubee Qallaa\",\"Dandii\",\"26\/5\/2006\",454,37,491],[90,\"Faajjii Galiilaa\",\"Dandii\",\"14\/4\/2006\",642,112,754],[91,\"Ifa Barii\",\"Dandii\",\"29\/9\/2010\",87,25,112],[92,\"Gaaleessaa Qotaa Geeshaar\",\"Dandii\",\"15\/08\/2010\",448,48,496],[93,\"Hawwii Guddina Qaqaroo Jibaat\",\"Daannoo\",\"2006\",348,10,358],[94,\"Abdii Borii\",\"Daannoo\",\"14\/01\/2007\",592,17,609],[95,\"Bakkee Finnoo\",\"Daannoo\",\"30\/02\/2005\",943,93,1036],[96,\"Baabboo Gasasoo\",\"Daannoo\",\"14\/01\/2007\",673,65,738],[97,\"Baddaa Iluu\",\"Daannoo\",\"2006\",298,20,318],[98,\"Naannoo Be'ee fi Kattaa\",\"Daannoo\",\"30\/02\/2005\",795,87,882],[99,\"Biiftuu\",\"Daannoo\",\"14\/01\/2007\",250,11,261],[100,\"Dagaagina Dirree Hujubaa\",\"Daannoo\",\"14\/01\/2007\",405,31,436],[101,\"Dirree Harrayyuu\",\"Daannoo\",\"14\/01\/2007\",468,43,511],[102,\"Dirree Daannoo\",\"Daannoo\",\"14\/01\/2007\",550,22,572],[103,\"Daannoo Roggee\",\"Daannoo\",\"1996\",546,19,565],[104,\"Guddina Awwadii Gulufaa\",\"Daannoo\",\"2006\",630,63,693],[105,\"Giddaa fi Abbuu\",\"Daannoo\",\"7\/6\/2005\",452,17,469],[106,\"Kaarraa Gannat\",\"Daannoo\",\"14\/2\/2004\",653,62,715],[107,\"Naannoo Ayyaruu\",\"Daannoo\",\"30\/02\/2005\",624,15,639],[108,\"Naannoo Qarsaa\",\"Daannoo\",\"1995\",614,27,641],[109,\"Naannoo Sayyoo\",\"Daannoo\",\"1997\",688,26,714],[110,\"Odaa Oboo\",\"Daannoo\",\"3\/5\/2005\",616,51,667],[111,\"Sayyoo Aabboo\",\"Daannoo\",\"29\/1\/2004\",672,36,708],[112,\"Safara Manzee\",\"Daannoo\",\"30\/02\/2005\",481,24,505],[113,\"Daannisaa Xanqoo\",\"Ejersa Lafoo\",\"2000\",455,201,656],[114,\"Gabaa Dilbataa\",\"Ejersa Lafoo\",\"\",1805,411,2216],[115,\"Oolankomii\",\"Ejersa Lafoo\",\"1992\",1860,447,2307],[116,\"Korrisoo Oddoo Gubaa\",\"Ejersa Lafoo\",\"4\/4\/2007\",430,50,480],[117,\"Gaarree Kooraa\",\"Ejersa Lafoo\",\"4\/4\/2007\",192,54,246],[118,\"Dagaa Eeguu\",\"Ejersa Lafoo\",\"4\/4\/2007\",276,39,315],[119,\"Awaash Waajituu\",\"Ejersa Lafoo\",\"4\/7\/2009\",467,101,568],[120,\"Waajituu\",\"Ejeree\",\"\",396,59,455],[121,\"Bakkee Boxii\",\"Gindabarat\",\"21\/04\/2008\",507,41,548],[122,\"Dirree Laga Dabal\",\"Gindabarat\",\"26\/12\/2008\",719,39,758],[123,\"Malkaa Qeelloo\",\"Gindabarat\",\"26\/5\/06\",63,47,110],[124,\"Culluxxee\",\"Gindabarat\",\"1997\",1336,312,1648],[125,\"Gooroo Mana Ergaa\",\"Gindabarat\",\"23\/2\/05\",1081,179,1260],[126,\"Gonfii Yabaloo\",\"Gindabarat\",\"29\/1\/2004\",1008,203,1211],[127,\"Goodaa Qunnii\",\"Gindabarat\",\"2006\",738,183,921],[128,\"Mudhii\",\"Gindabarat\",\"10\/3\/2006\",904,204,1108],[129,\"Naannoo Abunii\",\"Gindabarat\",\"26\/5\/2006\",1352,266,1618],[130,\"Naannoo Kaachisii\",\"Gindabarat\",\"29\/1\/2004\",870,355,1225],[131,\"Qarree Doobbii\",\"Gindabarat\",\"29\/1\/2004\",882,218,1100],[132,\"Winee Roggee\",\"Gindabarat\",\"29\/1\/2004\",1348,393,1741],[133,\"Qilxuu Sambataa\",\"Gindabarat\",\"2008\",339,109,448],[134,\"Gammachuu\",\"Iluu Galaan\",\"7\/4\/2007\",469,17,486],[135,\"Guddina Wadeeyyii Giraancee\",\"Iluu Galaan\",\"16\/5\/2008\",880,20,900],[136,\"Raachoo Dirqii\",\"Iluu Galaan\",\"1997\",328,67,395],[137,\"Raffisoo Qaamminoo\",\"Iluu Galaan\",\"3\/4\/2007\",737,15,752],[138,\"Siibaa Biichee\",\"Iluu Galaan\",\"3\/4\/2007\",596,57,653],[139,\"Siree Sillaasee\",\"Iluu Galaan\",\"3\/4\/2005\",276,29,305],[140,\"Baaroo\",\"Iluu Galaan\",\"12\/7\/1996\",878,143,1021],[141,\"Jaatoo Dirqii\",\"Iluu Galaan\",\"24\/1\/1997\",356,80,436],[142,\"Qilxuu Ilaalaa\",\"Iluu Galaan\",\"1995\",641,39,680],[143,\"Sadan Iluu\",\"Iluu Galaan\",\"30\/1\/2004\",803,143,946],[144,\"Guddina Warjii\",\"Iluu Galaan\",\"24\/5\/09\",759,45,804],[145,\"Guddina Walqixxee\",\"Iluu Galaan\",\"2\/4\/2011\",508,35,543],[146,\"Ambaltaa Godeettii\",\"Ilfata\",\"22\/3\/2008\",511,68,579],[147,\"Dhaabaa Madaanaalam\",\"Ilfata\",\"22\/5\/2006\",701,151,852],[148,\"Giccee\",\"Ilfata\",\"22\/3\/2008\",486,75,561],[149,\"Naannoo Gossoo Mikaa'eel\",\"Ilfata\",\"26\/05\/2006\",1084,109,1193],[150,\"Guutee Saadoo\",\"Ilfata\",\"28\/5\/06\",869,69,938],[151,\"Haroo Tuftichaa\",\"Ilfata\",\"23\/4\/06\",1175,266,1441],[152,\"Faallicha\",\"Ilfata\",\"3\/4\/2007\",403,54,457],[153,\"Hidhabuu Sandii\",\"Ilfata\",\"8\/4\/2007\",242,13,255],[154,\"Ittisaa Kooyyee\",\"Ilfata\",\"8\/4\/2007\",465,60,525],[155,\"Jirmaa Korbeessaa\",\"Ilfata\",\"3\/4\/2007\",293,32,325],[156,\"Somboo Cittuu\",\"Ilfata\",\"8\/4\/2007\",405,90,495],[157,\"Saaxoo Lukkuu\",\"Ilfata\",\"4\/4\/2007\",218,54,272],[158,\"Haaruu Sinaanii\",\"Ilfata\",\"5\/5\/2007\",197,68,265],[159,\"Xoosanyi Gafaree\",\"Ilfata\",\"3\/4\/2007\",603,95,698],[160,\"Cillaanqoo\",\"Jalduu\",\"29\/1\/2008\",573,169,742],[161,\"Edensa Galaan\",\"Jalduu\",\"3\/4\/2007\",779,199,978],[162,\"Shukutee\",\"Jalduu\",\"12\/6\/2006\",1489,105,1594],[163,\"Biichoo\",\"Jalduu\",\"1995\",1107,90,1197],[164,\"Bonii\",\"Jalduu\",\"1997\",1418,162,1580],[165,\"Kilbee\",\"Jalduu\",\"1995\",685,101,786],[166,\"Koluu\",\"Jalduu\",\"1997\",986,217,1203],[167,\"Sariitii\",\"Jalduu\",\"1997\",1007,167,1174],[168,\"Tasoo\",\"Jalduu\",\"1996\",879,76,955],[169,\"Urga'aa Eererii\",\"Jalduu\",\"22\/3\/2008\",500,54,554],[170,\"Tulluu Bultumaa\",\"Jalduu\",\"22\/3\/2008\",867,149,1016],[171,\"Tulluu Gurraa\",\"Jalduu\",\"22\/03\/2008\",796,109,905],[172,\"Abbayyii Reejii\",\"Jibaat\",\"15\/5\/2006\",182,21,203],[173,\"Adaammii Ukee\",\"Jibaat\",\"24\/03\/2008\",306,25,331],[174,\"Alii osoo\",\"Jibaat\",\"\",375,42,417],[175,\"Biloo Garbii\",\"Jibaat\",\"24\/6\/2006\",454,33,487],[176,\"Gaamoo Adaadii\",\"Jibaat\",\"28\/5\/2006\",498,51,549],[177,\"Ichaa Dikaa\",\"Jibaat\",\"2001\",433,72,505],[178,\"Kuyyuu Areeree\",\"Jibaat\",\"1998\",450,28,478],[179,\"Kuttaayee Muunyoo\",\"Jibaat\",\"2001\",519,49,568],[180,\"Muunyoo Wiixatee\",\"Jibaat\",\"2001\",554,55,609],[181,\"Maaruu Bahaa\",\"Jibaat\",\"3\/4\/2007\",275,30,305],[182,\"Maaruu Gajjaa\",\"Jibaat\",\"14\/4\/2006\",319,40,359],[183,\"Moluu Faallee\",\"Jibaat\",\"24\/03\/2008\",345,45,390],[184,\"Naannoo Shanan\",\"Jibaat\",\"28\/5\/2006\",665,76,741],[185,\"Dirree Xooxoo\",\"Liiban Jaawwii\",\"7\/4\/2007\",320,41,361],[186,\"Liiban\",\"Liiban Jaawwii\",\"\",1412,255,1667],[187,\"Tokkummaa Liiban\",\"Liiban Jaawwii\",\"28\/5\/06\",137,18,155],[188,\"Alaaltuu fi Dhirikoo\",\"Liiban Jaawwii\",\"24\/03\/2008\",224,24,248],[189,\"Cancaduu fi Masaraa\",\"Liiban Jaawwii\",\"1\/5\/2006\",453,58,511],[190,\"Gaamoo Yabaloo\",\"Liiban Jaawwii\",\"28\/5\/2006\",246,39,285],[191,\"Tulluu Baajoo\",\"Liiban Jaawwii\",\"16\/08\/2010\",363,82,445],[192,\"Agal Gobbuu Basaallee\",\"Liiban Jaawwii\",\"16\/08\/2010\",240,43,283],[193,\"Guddinaaf\",\"Liiban Jaawwii\",\"24\/03\/2008\",697,72,769],[194,\"Muunyoo Kashambal\",\"Liiban Jaawwii\",\"24\/03\/2008\",318,76,394],[195,\"Tokkee Kombolchaa\",\"Liiban Jaawwii\",\"15\/2\/1991\",835,162,997],[196,\"Naannoo Baabboo Gaalloo\",\"Liiban Jaawwii\",\"18\/04\/2006\",1020,197,1217],[197,\"Dirree Buuruu\",\"Midaa Qanyii\",\"22\/03\/2008\",355,11,366],[198,\"Goodaa Bixxillee\",\"Midaa Qanyii\",\"24\/5\/2006\",273,47,320],[199,\"Gambeela\",\"Midaa Qanyii\",\"22\/3\/2008\",75,5,80],[200,\"Goodaa Arbaa\",\"Midaa Qanyii\",\"24\/03\/2008\",223,11,234],[201,\"Tulluu Noonnoo\",\"Midaa Qanyii\",\"24\/5\/2006\",340,10,350],[202,\"Waayyuu Inkee\",\"Midaa Qanyii\",\"24\/03\/2008\",140,5,145],[203,\"Baaroo Bidaaruu\",\"Midaa Qanyii\",\"24\/5\/2006\",377,65,442],[204,\"Cuqqaalaa Wangee\",\"Midaa Qanyii\",\"2001\",637,23,660],[205,\"Dirree Lalisaa\",\"Midaa Qanyii\",\"2001\",425,45,470],[206,\"Goosuu Gonjii\",\"Midaa Qanyii\",\"2001\",644,62,706],[207,\"Galaan Gumjee\",\"Midaa Qanyii\",\"24\/5\/2006\",235,25,260],[208,\"Km\/Haroo Dirree Gadaa\",\"Midaa Qanyii\",\"24\/3\/2006\",300,41,341],[209,\"Harbuu Koobii\",\"Midaa Qanyii\",\"8\/4\/2007\",251,30,281],[210,\"Qanyii Gabreel\",\"Midaa Qanyii\",\"1997\",684,45,729],[211,\"Tulluu Lammii\",\"Midaa Qanyii\",\"\",93,4,97],[212,\"Waloo Taambaroo\",\"Midaa Qanyii\",\"18\/08\/2010\",191,62,253],[213,\"Biloo Waayyuu\",\"Noonnoo\",\"30\/1\/2007\",420,120,540],[214,\"Bakkee Mootii\",\"Noonnoo\",\"30\/1\/2007\",407,35,442],[215,\"Dikkoo Shuummoo\",\"Noonnoo\",\"30\/1\/2007\",386,100,486],[216,\"Hiilloo\",\"Noonnoo\",\"30\/1\/2007\",400,50,450],[217,\"Naannoo Qondaalaa\",\"Noonnoo\",\"27\/05\/2006\",422,23,445],[218,\"Biloo Meettaa\",\"Noonnoo\",\"24\/3\/2008\",350,66,416],[219,\"Burqaa Guddinaa\",\"Noonnoo\",\"22\/03\/2008\",567,56,623],[220,\"Caandoo\",\"Noonnoo\",\"22\/03\/2008\",397,55,452],[221,\"Caffee Odaa\",\"Noonnoo\",\"22\/03\/2008\",382,55,437],[222,\"Godaannoo\",\"Noonnoo\",\"22\/03\/2008\",350,30,380],[223,\"Hurrumuu Qorkee\",\"Noonnoo\",\"24\/03\/2005\",312,30,342],[224,\"Naannoo Halloo\",\"Noonnoo\",\"1998\",310,43,353],[225,\"Qonnooree Hurrumuu\",\"Noonnoo\",\"28\/5\/2007\",332,60,392],[226,\"Taltallee fi Beerree\",\"Noonnoo\",\"22\/03\/2008\",444,53,497],[227,\"Mattuu siillaasee\",\"Noonnoo\",\"26\/05\/2009\",687,34,721],[228,\"Qorkee Maariyaam\",\"Noonnoo\",\"29\/03\/2008\",323,30,353],[229,\"Hurrumuu Gabreel\",\"Noonnoo\",\"15\/4\/2011\",405,52,457],[230,\"Dambii\",\"Noonnoo\",\"24\/3\/2008\",354,43,397],[231,\"Tokkee Arfinjoo\",\"Tokkee Kuttaayee\",\"24\/03\/2008\",307,34,341],[232,\"Mutuluu\",\"Tokkee Kuttaayee\",\"15\/2\/1991\",1783,136,1919],[233,\"Qilinxoo\",\"Tokkee Kuttaayee\",\"1994\",1474,568,2042],[234,\"Tokkee Gabaa Kamisaa\",\"Tokkee Kuttaayee\",\"15\/2\/1991\",1391,95,1486],[235,\"Tokkee Gooroo Soolee\",\"Tokkee Kuttaayee\",\"2000\",1195,143,1338],[236,\"Tokkee Irreensaa\",\"Tokkee Kuttaayee\",\"15\/2\/1991\",1043,65,1108],[237,\"Naannoo Wajiiraa\",\"Tokkee Kuttaayee\",\"1997\",589,22,611],[238,\"Guddina Laaluu\",\"Tokkee Kuttaayee\",\"25\/07\/09\",60,1,61],[239,\"Hadharsaa Biilaa\",\"Tokkee Kuttaayee\",\"2010\",190,16,206],[240,\"Hundee Guddinaa\",\"Tokkee Kuttaayee\",\"2004\",463,158,621],[241,\"Daadaa Galaan\",\"Tokkee Kuttaayee\",\"2004\",614,141,755],[242,\"Malkaa Nagaa Dambii\",\"Tokkee Kuttaayee\",\"2004\",614,141,755],[243,\"G\/O\/Q Kolbaa\",\"Tokkee Kuttaayee\",\"2004\",418,38,456],[244,\"Oolee Sillaasee\",\"Tokkee Kuttaayee\",\"2004\",220,55,275],[245,\"Fincaa'aa Malkee\",\"Tokkee Kuttaayee\",\"2004\",459,138,597],[246,\"Tulluu\",\"Tokkee Kuttaayee\",\"2004\",224,27,251],[247,\"Badhaasaa\",\"Tokkee Kuttaayee\",\"2004\",463,158,621],[248,\"Baddeessaa Dambii\",\"Ab\/ Gindabarat\",\"23\/3\/2012\",117,1,118],[249,\"Gobbaa Waashamoo\",\"Iluu Galaan\",\"23\/3\/2012\",236,20,256],[250,\"Haroo Dhagaa Dhaabaa\",\"Jalduu\",\"23\/3\/2012\",1136,90,1226],[251,\"Gaamoo Jibaat\",\"Jibaat\",\"23\/3\/2012\",191,25,216],[252,\"Gaamoo Walisoo\",\"Liiban Jaawwii\",\"23\/3\/2012\",195,17,212],[253,\"Irreensa Baadiyyaa\",\"Liiban Jaawwii\",\"23\/3\/2012\",305,54,359],[254,\"Alii Abbo Saree\",\"Noonnoo\",\"4\/4\/2012\",372,53,425],[255,\"Mattuu Silmii\",\"Noonnoo\",\"15\/4\/2011\",385,85,470],[256,\"Alii Narvoo\",\"Noonnoo\",\"29\/3\/2011\",302,40,342],[257,\"Alii Alakaasee\",\"Noonnoo\",\"2\/4\/2011\",358,28,386],[258,\"Abbayyii Heebanii\",\"Noonnoo\",\"6\/4\/2013\",400,76,476],[259,\"Ancabbii Baddeessoo\",\"Daannoo\",\"6\/4\/2013\",351,16,367],[260,\"Caancoo Qabbanaa'aa\",\"Jalduu\",\"7\/7\/2013\",517,98,615],[261,\"Galmoo Warabboo\",\"Noonnoo\",\"6\/4\/2013\",403,39,442],[262,\"Hullugeetaa Karrayyuu\",\"Noonnoo\",\"6\/4\/2013\",322,37,359],[263,\"Hurrumuu Jibaat\",\"Noonnoo\",\"6\/4\/2013\",312,30,342],[264,\"Intoo Daallee\",\"Jalduu\",\"20\/05\/2013\",366,61,427],[265,\"Meettaa Warjii\",\"Iluu Galaan\",\"6\/4\/2013\",759,45,804],[266,\"Halloo Dinkii\",\"Noonnoo\",\"5\/4\/2014\",401,65,466],[267,\"Biiftuu Jaalalaa\",\"Noonnoo\",\"5\/4\/2014\",550,120,670],[268,\"Jiruu Gammachuu\",\"Noonnoo\",\"5\/4\/2014\",948,47,995],[269,\"G\/ Haleeluu Odaa Guutaa\",\"Calliyaa\",\"5\/4\/2014\",284,40,324],[270,\"Coomee Mana Ergaa\",\"Gindabarat\",\"5\/4\/2014\",265,157,422],[271,\"Muka Diimaa\",\"Gindabarat\",\"5\/4\/2014\",993,491,1484],[272,\"Tokkummaa Burqaa Guddinaa\",\"Bul. BM Amboo\",\"23\/4\/2015\",147,50,197],[273,\"Badhaastuu\",\"Dirree Incinnii\",\"22\/04\/2015\",21,5,26],[274,\"Gololee\",\"Noonnoo\",\"15\/06\/2015\",450,100,550],[275,\"Biloo Aabboo\",\"Noonnoo\",\"2\/5\/2016\",312,30,342],[276,\"Naannoo Sanqallee\",\"Bul. BM Amboo\",\"26\/04\/2018\",610,358,968],[277,\"Guddina Jijjiguu\",\"Amboo\",\"26\/04\/2018\",81,1,82],[278,\"Bagaalloo Gabbisaa\",\"Amboo\",\"26\/04\/2018\",108,0,108],[279,\"Tulluu Gurjii\",\"Jalduu\",\"26\/04\/2018\",92,6,98],[280,\"Guddina Oborraa\",\"Iluu Galaan\",\"26\/04\/2018\",399,60,459],[281,\"Mixaarii Heebanii\",\"Noonnoo\",\"26\/04\/2018\",139,17,156],[282,\"Imbooroo\",\"Noonnoo\",\"26\/04\/2018\",524,36,560],[283,\"Naannoo Goljaa\",\"Amboo\",\"26\/04\/2018\",625,25,650],[284,\"Obbee Kuraa\",\"Midaa Qanyii\",\"26\/04\/2018\",350,54,404]\n ];\n\n let globalData = [...cooperativesData];\n let currentDisplayData = [...globalData];\n let coopChart, memberChart;\n\n function aggregateWoreda(data) {\n const map = new Map();\n data.forEach(row => {\n let w = row[2].trim();\n if (!map.has(w)) map.set(w, { count: 0, totalMembers: 0 });\n let val = map.get(w);\n val.count++;\n val.totalMembers += row[6];\n });\n return map;\n }\n\n function updateChartsAndTotals(data) {\n const agg = aggregateWoreda(data);\n const woredas = Array.from(agg.keys()).sort();\n const coopCounts = woredas.map(w => agg.get(w).count);\n const memberTotals = woredas.map(w => agg.get(w).totalMembers);\n \n document.getElementById('totalWoredasCount').innerText = woredas.length;\n \n if (coopChart) coopChart.destroy();\n if (memberChart) memberChart.destroy();\n \n const ctx1 = document.getElementById('coopWoredaChart').getContext('2d');\n coopChart = new Chart(ctx1, {\n type: 'bar',\n data: { labels: woredas, datasets: [{ label: 'Number of coops', data: coopCounts, backgroundColor: '#e6b13e', borderRadius: 8 }] },\n options: { responsive: true, maintainAspectRatio: false, plugins: { legend: { display: false } }, scales: { y: { beginAtZero: true, ticks: { stepSize: 1 } } } }\n });\n \n const ctx2 = document.getElementById('membersWoredaChart').getContext('2d');\n memberChart = new Chart(ctx2, {\n type: 'bar',\n data: { labels: woredas, datasets: [{ label: 'Total members', data: memberTotals, backgroundColor: '#2c8c3e', borderRadius: 8 }] },\n options: { responsive: true, maintainAspectRatio: false, plugins: { legend: { display: false } }, scales: { y: { beginAtZero: true } } }\n });\n \n \/\/ totals summary\n let totalMale = 0, totalFemale = 0, totalMembers = 0;\n data.forEach(r => { totalMale += r[4]; totalFemale += r[5]; totalMembers += r[6]; });\n document.getElementById('totalMaleSpan').innerText = totalMale.toLocaleString();\n document.getElementById('totalFemaleSpan').innerText = totalFemale.toLocaleString();\n document.getElementById('totalMembersSum').innerText = totalMembers.toLocaleString();\n document.getElementById('rowCountDisplay').innerHTML = data.length + ' entries';\n }\n\n function renderTable(data) {\n const tbody = document.getElementById('tableBody');\n tbody.innerHTML = '';\n data.forEach(row => {\n const tr = document.createElement('tr');\n tr.innerHTML = `\n <td>${row[0]}<\/td>\n <td>${escapeHtml(row[1])}<\/td>\n <td>${escapeHtml(row[2])}<\/td>\n <td>${row[3] || '\u2014'}<\/td>\n <td>${row[4].toLocaleString()}<\/td>\n <td>${row[5].toLocaleString()}<\/td>\n <td>${row[6].toLocaleString()}<\/td>\n `;\n tbody.appendChild(tr);\n });\n updateChartsAndTotals(data);\n currentDisplayData = data;\n }\n \n function escapeHtml(str) { return String(str).replace(\/[&<>]\/g, function(m){ if(m === '&') return '&'; if(m === '<') return '<'; if(m === '>') return '>'; return m;}); }\n \n function filterTable() {\n const query = document.getElementById('searchInput').value.toLowerCase();\n const filtered = globalData.filter(row => \n row[1].toLowerCase().includes(query) || \n row[2].toLowerCase().includes(query) || \n (row[3] && row[3].toLowerCase().includes(query))\n );\n renderTable(filtered);\n }\n \n function exportToExcel(type) {\n const dataToExport = (type === 'all') ? globalData : currentDisplayData;\n const sheetData = [['SN', 'Cooperative Name', 'Woreda', 'Membership Date', 'Male', 'Female', 'Total Members'],\n ...dataToExport.map(r => [r[0], r[1], r[2], r[3] || '', r[4], r[5], r[6]])];\n const wb = XLSX.utils.book_new();\n const ws = XLSX.utils.aoa_to_sheet(sheetData);\n XLSX.utils.book_append_sheet(wb, ws, 'AFCU_Cooperatives');\n XLSX.writeFile(wb, `afcu_cooperatives_${type}_${new Date().toISOString().slice(0,10)}.xlsx`);\n }\n \n document.getElementById('searchInput').addEventListener('keyup', filterTable);\n document.getElementById('exportAllBtn').onclick = () => exportToExcel('all');\n document.getElementById('exportFilteredBtn').onclick = () => exportToExcel('filtered');\n \n renderTable(globalData);\n<\/script>\n<\/body>\n<\/html>\n","protected":false},"excerpt":{"rendered":"<p>AFCU \u00b7 West Shewa Analytics \u00b7 284 Primary Cooperatives Ambo Farmers’ Cooperative Union LTD est. 1998 www.afcu.org.et \u00b7 official cooperative data West Shewa \u00b7 284 coops \u2014 Woredas 284 Primary Coops \u2014 Total Members Male members: 0 Female members: 0 Woreda-wise aggregation \u00b7 284 cooperatives from official registry Cooperatives per Woreda Total Members per Woreda…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"fullwidth","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-235","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/posts\/235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afcu.org.et\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=235"}],"version-history":[{"count":14,"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions"}],"predecessor-version":[{"id":1133,"href":"https:\/\/afcu.org.et\/index.php?rest_route=\/wp\/v2\/posts\/235\/revisions\/1133"}],"wp:attachment":[{"href":"https:\/\/afcu.org.et\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afcu.org.et\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afcu.org.et\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}