Spreadsheet: 172681d1344288143-sum-formula-not-working-working-capital-dashboard
Sheet: DATA

Branch | Working Capital | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00
Branch 1 | Inventory | 192 | 201 | 209 | 210 | 222 | 237 | 256 | 268 | 277 | 299 | 326 | 331 | 336 | 358 | 376 | 394 | 406 | 443 | 481 | 502 | 516 | 517 | 564 | 587
Branch 2 | Inventory | 784 | 821 | 890 | 962 | 1014 | 1077 | 1078 | 1097 | 1185 | 1231 | 1302 | 1414 | 1517 | 1615 | 1615 | 1738 | 1860 | 1949 | 2129 | 2253 | 2472 | 2648 | 2781 | 2966
Branch 3 | Inventory | 764 | 789 | 832 | 862 | 876 | 933 | 940 | 981 | 1072 | 1091 | 1153 | 1201 | 1307 | 1320 | 1402 | 1530 | 1566 | 1589 | 1642 | 1745 | 1848 | 1932 | 2072 | 2119
Branch 4 | Inventory | 676 | 717 | 764 | 792 | 841 | 841 | 900 | 920 | 1008 | 1071 | 1157 | 1264 | 1276 | 1313 | 1425 | 1502 | 1562 | 1676 | 1765 | 1796 | 1885 | 1920 | 1924 | 2021
Branch 5 | Inventory | 697 | 742 | 791 | 851 | 871 | 928 | 991 | 1077 | 1089 | 1119 | 1133 | 1169 | 1172 | 1226 | 1314 | 1431 | 1525 | 1617 | 1657 | 1792 | 1888 | 1925 | 2000 | 2152
Branch 6 | Inventory | 356 | 369 | 369 | 384 | 400 | 435 | 468 | 499 | 543 | 558 | 607 | 649 | 709 | 745 | 799 | 864 | 897 | 952 | 953 | 1016 | 1031 | 1100 | 1113 | 1222
Branch 7 | Inventory | 40 | 41 | 43 | 47 | 49 | 53 | 56 | 60 | 63 | 65 | 69 | 74 | 80 | 81 | 88 | 95 | 101 | 105 | 112 | 114 | 124 | 128 | 133 | 139
Branch 8 | Inventory | 104 | 110 | 120 | 127 | 130 | 142 | 153 | 159 | 164 | 166 | 182 | 200 | 202 | 213 | 222 | 240 | 253 | 258 | 261 | 281 | 288 | 301 | 317 | 347
Branch 9 | Inventory | 336 | 369 | 391 | 427 | 469 | 497 | 543 | 554 | 576 | 623 | 676 | 709 | 734 | 780 | 816 | 857 | 933 | 1018 | 1046 | 1078 | 1094 | 1185 | 1217 | 1222
Branch 10 | Inventory | 310 | 319 | 323 | 335 | 348 | 351 | 371 | 389 | 405 | 442 | 442 | 465 | 480 | 497 | 523 | 562 | 611 | 620 | 655 | 716 | 721 | 753 | 780 | 853
Branch 11 | Inventory | 727 | 742 | 798 | 866 | 882 | 930 | 1002 | 1029 | 1104 | 1204 | 1293 | 1315 | 1442 | 1552 | 1572 | 1699 | 1805 | 1937 | 2069 | 2098 | 2106 | 2133 | 2289 | 2385
Branch 12 | Inventory | 466 | 479 | 480 | 523 | 561 | 591 | 604 | 635 | 644 | 654 | 684 | 739 | 758 | 782 | 792 | 809 | 856 | 885 | 954 | 1039 | 1123 | 1149 | 1176 | 1223
Branch 13 | Inventory | 114 | 124 | 130 | 133 | 138 | 148 | 157 | 168 | 181 | 198 | 206 | 224 | 246 | 257 | 270 | 289 | 310 | 314 | 333 | 344 | 345 | 377 | 414 | 419
Branch 14 | Inventory | 801 | 826 | 887 | 976 | 1011 | 1097 | 1191 | 1255 | 1298 | 1357 | 1481 | 1559 | 1568 | 1610 | 1671 | 1784 | 1936 | 2128 | 2199 | 2338 | 2551 | 2726 | 2994 | 3293
Branch 15 | Inventory | 912 | 940 | 965 | 1052 | 1122 | 1164 | 1257 | 1320 | 1401 | 1475 | 1598 | 1609 | 1684 | 1833 | 1915 | 1978 | 2031 | 2092 | 2301 | 2333 | 2442 | 2443 | 2558 | 2762
Branch 1 | Receivables | 847 | 878 | 962 | 1004 | 1075 | 1174 | 1283 | 1357 | 1377 | 1422 | 1548 | 1699 | 1745 | 1773 | 1950 | 2028 | 2176 | 2306 | 2316 | 2419 | 2539 | 2700 | 2968 | 3125
Branch 2 | Receivables | 725 | 727 | 736 | 768 | 786 | 832 | 860 | 903 | 939 | 976 | 981 | 1032 | 1120 | 1134 | 1194 | 1233 | 1286 | 1366 | 1440 | 1581 | 1693 | 1827 | 1838 | 2006
Branch 3 | Receivables | 65 | 69 | 76 | 79 | 87 | 95 | 97 | 100 | 109 | 111 | 113 | 116 | 117 | 126 | 127 | 129 | 133 | 136 | 141 | 149 | 154 | 170 | 186 | 193
Branch 4 | Receivables | 872 | 898 | 956 | 1027 | 1112 | 1209 | 1283 | 1346 | 1356 | 1463 | 1544 | 1620 | 1754 | 1817 | 1835 | 2018 | 2149 | 2273 | 2483 | 2559 | 2725 | 2863 | 3112 | 3270
Branch 5 | Receivables | 321 | 328 | 359 | 369 | 384 | 395 | 420 | 433 | 439 | 455 | 476 | 522 | 535 | 547 | 560 | 575 | 597 | 617 | 644 | 698 | 743 | 797 | 808 | 864
Branch 6 | Receivables | 735 | 735 | 771 | 790 | 798 | 815 | 878 | 927 | 1013 | 1020 | 1109 | 1146 | 1158 | 1268 | 1317 | 1379 | 1436 | 1466 | 1544 | 1631 | 1784 | 1892 | 1905 | 1977
Branch 7 | Receivables | 472 | 506 | 531 | 580 | 636 | 662 | 727 | 777 | 816 | 875 | 959 | 1040 | 1049 | 1133 | 1202 | 1207 | 1226 | 1320 | 1401 | 1466 | 1540 | 1602 | 1728 | 1747
Branch 8 | Receivables | 115 | 116 | 124 | 131 | 135 | 137 | 144 | 158 | 169 | 176 | 183 | 200 | 209 | 229 | 241 | 257 | 262 | 274 | 284 | 310 | 333 | 362 | 386 | 394
Branch 9 | Receivables | 460 | 481 | 522 | 557 | 568 | 578 | 613 | 634 | 653 | 702 | 760 | 813 | 856 | 884 | 962 | 963 | 1053 | 1092 | 1093 | 1116 | 1198 | 1212 | 1301 | 1305
Branch 10 | Receivables | 713 | 736 | 782 | 859 | 881 | 969 | 1004 | 1015 | 1104 | 1179 | 1194 | 1227 | 1244 | 1247 | 1347 | 1468 | 1486 | 1613 | 1629 | 1732 | 1833 | 1982 | 2071 | 2148
Branch 11 | Receivables | 957 | 960 | 1039 | 1065 | 1089 | 1125 | 1155 | 1203 | 1216 | 1337 | 1348 | 1425 | 1557 | 1586 | 1635 | 1635 | 1737 | 1881 | 1948 | 2028 | 2194 | 2250 | 2343 | 2525
Branch 12 | Receivables | 987 | 1039 | 1054 | 1092 | 1183 | 1222 | 1288 | 1355 | 1370 | 1380 | 1401 | 1421 | 1434 | 1474 | 1552 | 1570 | 1686 | 1804 | 1855 | 1892 | 1922 | 2090 | 2152 | 2215
Branch 13 | Receivables | 535 | 555 | 590 | 603 | 652 | 715 | 756 | 781 | 783 | 852 | 931 | 1014 | 1060 | 1165 | 1257 | 1295 | 1302 | 1358 | 1469 | 1610 | 1664 | 1770 | 1782 | 1822
Branch 14 | Receivables | 645 | 694 | 736 | 762 | 831 | 868 | 874 | 874 | 947 | 948 | 1030 | 1070 | 1130 | 1167 | 1224 | 1235 | 1352 | 1460 | 1588 | 1637 | 1760 | 1926 | 1977 | 2048
Branch 15 | Receivables | 899 | 951 | 952 | 1038 | 1084 | 1097 | 1132 | 1217 | 1257 | 1303 | 1358 | 1475 | 1621 | 1771 | 1896 | 2035 | 2138 | 2292 | 2437 | 2660 | 2907 | 3102 | 3165 | 3327
Branch 1 | Payables | 914 | 914 | 925 | 1005 | 1051 | 1088 | 1103 | 1130 | 1221 | 1320 | 1450 | 1519 | 1658 | 1712 | 1793 | 1847 | 1981 | 2017 | 2090 | 2244 | 2369 | 2466 | 2522 | 2745
Branch 2 | Payables | 125 | 130 | 143 | 144 | 151 | 164 | 175 | 180 | 188 | 206 | 211 | 231 | 241 | 249 | 264 | 280 | 300 | 308 | 329 | 342 | 345 | 349 | 361 | 381
Branch 3 | Payables | 955 | 968 | 1042 | 1145 | 1206 | 1240 | 1354 | 1384 | 1478 | 1518 | 1582 | 1589 | 1747 | 1876 | 1943 | 2101 | 2117 | 2164 | 2261 | 2357 | 2526 | 2690 | 2831 | 2991
Branch 4 | Payables | 704 | 749 | 811 | 821 | 888 | 937 | 978 | 1072 | 1124 | 1137 | 1190 | 1190 | 1257 | 1267 | 1327 | 1381 | 1455 | 1479 | 1540 | 1635 | 1645 | 1684 | 1818 | 1998
Branch 5 | Payables | 65 | 69 | 70 | 76 | 82 | 88 | 88 | 94 | 102 | 102 | 108 | 111 | 117 | 126 | 127 | 135 | 144 | 149 | 161 | 176 | 190 | 190 | 201 | 210
Branch 6 | Payables | 858 | 908 | 947 | 976 | 997 | 1024 | 1086 | 1122 | 1170 | 1204 | 1316 | 1338 | 1341 | 1455 | 1462 | 1577 | 1734 | 1757 | 1779 | 1807 | 1809 | 1963 | 2148 | 2183
Branch 7 | Payables | 160 | 162 | 177 | 189 | 200 | 210 | 226 | 240 | 242 | 245 | 254 | 262 | 271 | 279 | 303 | 323 | 353 | 355 | 366 | 398 | 430 | 462 | 467 | 485
Branch 8 | Payables | 559 | 586 | 590 | 597 | 643 | 707 | 768 | 830 | 870 | 948 | 982 | 1066 | 1086 | 1125 | 1129 | 1238 | 1308 | 1412 | 1537 | 1670 | 1676 | 1694 | 1701 | 1815
Branch 9 | Payables | 892 | 925 | 926 | 937 | 1006 | 1067 | 1073 | 1093 | 1194 | 1200 | 1206 | 1302 | 1362 | 1442 | 1532 | 1533 | 1587 | 1737 | 1884 | 1994 | 2153 | 2292 | 2314 | 2529
Branch 10 | Payables | 26 | 28 | 29 | 30 | 31 | 34 | 34 | 38 | 39 | 40 | 41 | 44 | 46 | 46 | 47 | 50 | 52 | 54 | 55 | 57 | 59 | 64 | 69 | 75
Branch 11 | Payables | 685 | 709 | 711 | 778 | 829 | 908 | 919 | 993 | 995 | 1069 | 1128 | 1198 | 1249 | 1361 | 1444 | 1575 | 1670 | 1774 | 1874 | 1891 | 1931 | 1939 | 1941 | 2038
Branch 12 | Payables | 366 | 397 | 432 | 455 | 474 | 508 | 544 | 553 | 578 | 589 | 627 | 678 | 738 | 764 | 818 | 828 | 888 | 929 | 986 | 1073 | 1120 | 1142 | 1203 | 1309
Branch 13 | Payables | 192 | 198 | 214 | 215 | 220 | 224 | 228 | 240 | 249 | 270 | 287 | 302 | 325 | 350 | 362 | 396 | 404 | 407 | 419 | 458 | 464 | 494 | 538 | 562
Branch 14 | Payables | 135 | 139 | 152 | 165 | 178 | 194 | 194 | 203 | 205 | 221 | 231 | 235 | 251 | 253 | 262 | 266 | 284 | 285 | 294 | 301 | 324 | 341 | 357 | 373
Branch 15 | Payables | 177 | 184 | 201 | 219 | 241 | 254 | 269 | 279 | 287 | 304 | 331 | 340 | 361 | 366 | 376 | 406 | 428 | 433 | 442 | 459 | 475 | 508 | 554 | 567
Branch 1 | Intra Group | 213 | 224 | 242 | 246 | 270 | 283 | 295 | 305 | 324 | 339 | 342 | 365 | 388 | 412 | 433 | 463 | 486 | 503 | 526 | 570 | 625 | 626 | 649 | 657
Branch 2 | Intra Group | 162 | 166 | 182 | 199 | 202 | 221 | 233 | 248 | 272 | 278 | 281 | 286 | 312 | 323 | 345 | 355 | 387 | 389 | 411 | 450 | 461 | 468 | 476 | 500
Branch 3 | Intra Group | 288 | 304 | 307 | 329 | 352 | 355 | 390 | 401 | 412 | 435 | 476 | 478 | 522 | 526 | 576 | 609 | 649 | 689 | 697 | 704 | 749 | 759 | 800 | 851
Branch 4 | Intra Group | 162 | 178 | 195 | 196 | 206 | 221 | 227 | 234 | 255 | 259 | 285 | 310 | 327 | 346 | 379 | 399 | 402 | 410 | 436 | 451 | 460 | 500 | 539 | 553
Branch 5 | Intra Group | 436 | 438 | 471 | 492 | 511 | 546 | 558 | 591 | 614 | 623 | 656 | 689 | 753 | 755 | 800 | 862 | 926 | 955 | 1025 | 1046 | 1052 | 1084 | 1085 | 1086
Branch 6 | Intra Group | 71 | 71 | 74 | 77 | 79 | 83 | 90 | 98 | 107 | 115 | 123 | 132 | 145 | 153 | 162 | 175 | 192 | 200 | 216 | 226 | 231 | 246 | 248 | 258
Branch 7 | Intra Group | 902 | 933 | 940 | 1014 | 1103 | 1163 | 1272 | 1286 | 1373 | 1427 | 1510 | 1570 | 1644 | 1662 | 1818 | 1963 | 2064 | 2254 | 2362 | 2397 | 2610 | 2633 | 2685 | 2738
Branch 8 | Intra Group | 437 | 448 | 466 | 492 | 541 | 546 | 550 | 560 | 596 | 636 | 682 | 708 | 768 | 827 | 869 | 871 | 908 | 985 | 1017 | 1094 | 1099 | 1124 | 1214 | 1217
Branch 9 | Intra Group | 919 | 995 | 1044 | 1060 | 1114 | 1211 | 1280 | 1307 | 1359 | 1456 | 1594 | 1738 | 1899 | 1998 | 2189 | 2225 | 2245 | 2296 | 2406 | 2521 | 2564 | 2723 | 2810 | 2982
Branch 10 | Intra Group | 358 | 388 | 401 | 418 | 421 | 449 | 449 | 456 | 463 | 465 | 509 | 516 | 567 | 606 | 649 | 693 | 714 | 720 | 727 | 769 | 805 | 830 | 842 | 907
Branch 11 | Intra Group | 989 | 1034 | 1072 | 1178 | 1288 | 1315 | 1440 | 1484 | 1632 | 1704 | 1733 | 1867 | 1868 | 1881 | 2060 | 2098 | 2299 | 2352 | 2368 | 2442 | 2456 | 2698 | 2780 | 2930
Branch 12 | Intra Group | 674 | 688 | 733 | 806 | 842 | 887 | 938 | 974 | 1020 | 1114 | 1118 | 1190 | 1284 | 1362 | 1371 | 1484 | 1491 | 1542 | 1603 | 1655 | 1741 | 1793 | 1804 | 1808
Branch 13 | Intra Group | 815 | 874 | 920 | 992 | 1026 | 1073 | 1092 | 1121 | 1168 | 1214 | 1252 | 1347 | 1409 | 1466 | 1559 | 1610 | 1621 | 1693 | 1771 | 1798 | 1919 | 2016 | 2024 | 2225
Branch 14 | Intra Group | 205 | 216 | 217 | 236 | 251 | 275 | 278 | 299 | 328 | 349 | 376 | 408 | 444 | 446 | 451 | 478 | 500 | 505 | 509 | 554 | 571 | 623 | 642 | 676
Branch 15 | Intra Group | 248 | 265 | 282 | 305 | 328 | 342 | 360 | 379 | 380 | 405 | 413 | 447 | 483 | 529 | 537 | 587 | 644 | 649 | 683 | 740 | 751 | 776 | 850 | 916