Gantt

big_gantt_schedule.csv

activity,dependencies,expected_time,planned_start,planned_end
0,[],9.32,0.0,9.32
1,[],2.37,0.0,2.37
2,[],5.94,0.0,5.94
3,[],3.81,0.0,3.81
4,[0],2.06,9.32,11.38
...
4994,"[454, 4953, 4979, 4972, 4988, 4867, 4889, 4914, 4909, 4882, 4839, 4841, 4819, 4855, 4776, 4781, 4798, 4788, 4787, 4757, 4755, 4735, 4693, 4679, 4656, 4624, 4630, 4620, 4589, 4581, 4546, 4550, 4560, 4559, 4549, 4552, 4563, 4541, 4509, 4514, 4499, 4500, 4498, 4496, 4506, 4504, 4476, 4486, 4472, 4464, 4458, 4449, 4439, 4429, 4411, 4420, 4419, 4398, 4392, 4383, 4374, 4307, 4312, 4300, 4287, 4283, 4262, 4255, 4232, 4233, 4210, 4208, 4177, 4178, 4176, 4152, 4142, 4146, 4129, 4130, 4118, 4112, 4111, 4113, 4099, 4100, 4091, 4084, 4078, 4080, 4068, 4032, 4033, 4026, 4024, 4011, 4014, 4004, 4006, 3997, 3984, 3975, 3977, 3960, 3953, 3919, 3911, 3901, 3900, 3878, 3869, 3868, 3864, 3832, 3815, 3810, 3792, 3776, 3773, 3763, 3752, 3719, 3710, 3706, 3690, 3687, 3682, 3669, 3652, 3653, 3645, 3643, 3640, 3612, 3614, 3596, 3584, 3587, 3572, 3576, 3574, 3566, 3551, 3548, 3536, 3518, 3501, 3491, 3490, 3478, 3466, 3460, 3446, 3440, 3429, 3407, 3401, 3398, 3396, 3343, 3326, 3325, 3313, 3306, 3304, 3298, 3289, 3287, 3267, 3265, 3221, 3225, 3218, 3224, 3190, 3181, 3188, 3164, 3152, 3157, 3139, 3125, 3118, 3079, 3074, 3071, 3060, 3055, 3038, 3037, 3001, 2995, 2960, 2965, 2952, 2948, 2933, 2936, 2929, 2924, 2914, 2910, 2902, 2900, 2897, 2886, 2880, 2863, 2855, 2854, 2845, 2819, 2782, 2781, 2773, 2762, 2748, 2754, 2724, 2725, 2723, 2714, 2706, 2682, 2678, 2633, 2612, 2602, 2595, 2586, 2577, 2574, 2571, 2568, 2565, 2541, 2544, 2512, 2520, 2505, 2502, 2488, 2472, 2464, 2459, 2440, 2438, 2426, 2432, 2417, 2415, 2409, 2399, 2392, 2366, 2370, 2343, 2333, 2296, 2301, 2290, 2277, 2278, 2273, 2257, 2251, 2240, 2239, 2232, 2233, 2213, 2194, 2198, 2181, 2162, 2158, 2148, 2137, 2135, 2124, 2108, 2104, 2097, 2094, 2100, 2086, 2079, 2063, 2067, 2039, 2029, 2037, 2033, 2028, 2023, 2014, 1992, 1987, 1984, 1978, 1974, 1972, 1960, 1961, 1933, 1923, 1919, 1914, 1899, 1897, 1892, 1900, 1890, 1862, 1856, 1813, 1820, 1819, 1814, 1794, 1800, 1792, 1791, 1782, 1780, 1772, 1766, 1757, 1750, 1748, 1736, 1730, 1720, 1715, 1707, 1709, 1712, 1694, 1688, 1677, 1667, 1670, 1669, 1654, 1647, 1651, 1641, 1631, 1635, 1636, 1625, 1622, 1602, 1600, 1567, 1553, 1536, 1523, 1493, 1483, 1476, 1471, 1457, 1442, 1443, 1436, 1426, 1421, 1417, 1400, 1375, 1355, 1346, 1343, 1332, 1294, 1258, 1263, 1252, 1238, 1236, 1235, 1233, 1226, 1178, 1182, 1158, 1145, 1118, 1059, 1050, 1045, 1042, 1019, 1000, 984, 985, 970, 942, 930, 925, 924, 921, 908, 914, 892, 893, 895, 885, 868, 865, 840, 838, 831, 836, 825, 826, 823, 828, 806, 809, 801, 789, 779, 754, 760, 748, 716, 703, 700, 694, 679, 682, 658, 646, 651, 638, 619, 617, 612, 594, 581, 568, 564, 558, 552, 555, 554, 551, 550, 498, 488, 494, 485, 482, 468, 464, 7, 4, 10, 23, 44, 43, 57, 58, 53, 77, 73, 84, 79, 116, 144, 146, 154, 151, 172, 195, 206, 213, 208, 251, 263, 269, 274, 285, 284, 300, 294, 304, 311, 312, 328, 323, 340, 345, 363, 376, 375, 385, 391, 406, 422, 428, 430, 447, 444, 458]",0.42,4586.569999999992,4586.9899999999925
4995,"[430, 4962, 4956, 4934, 4980, 4970, 4991, 4963, 4994, 4918, 4985, 4923, 4861, 4915, 4890, 4876, 4846, 4835, 4812, 4842, 4837, 4851, 4838, 4784, 4811, 4798, 4790, 4793, 4795, 4742, 4771, 4729, 4710, 4726, 4682, 4703, 4696, 4672, 4650, 4634, 4620, 4590, 4594, 4606, 4595, 4593, 4575, 4580, 4554, 4564, 4550, 4516, 4522, 4498, 4501, 4463, 4458, 4396, 4405, 4398, 4382, 4390, 4378, 4362, 4343, 4341, 4290, 4289, 4271, 4279, 4273, 4264, 4251, 4237, 4234, 4223, 4198, 4194, 4178, 4183, 4179, 4175, 4161, 4168, 4158, 4142, 4147, 4129, 4118, 4125, 4122, 4110, 4115, 4097, 4105, 4079, 4083, 4080, 4070, 4073, 4059, 4062, 4051, 4034, 4018, 4005, 4007, 3992, 3983, 3960, 3965, 3918, 3909, 3894, 3886, 3889, 3865, 3863, 3860, 3859, 3836, 3837, 3809, 3763, 3737, 3734, 3720, 3717, 3699, 3689, 3648, 3620, 3607, 3606, 3592, 3596, 3583, 3588, 3580, 3554, 3555, 3536, 3523, 3511, 3514, 3504, 3483, 3473, 3458, 3450, 3437, 3432, 3404, 3407, 3365, 3368, 3363, 3358, 3339, 3334, 3330, 3324, 3308, 3312, 3310, 3300, 3287, 3294, 3281, 3263, 3252, 3255, 3230, 3211, 3216, 3204, 3202, 3194, 3193, 3187, 3173, 3177, 3175, 3167, 3165, 3145, 3120, 3105, 3106, 3097, 3068, 3063, 3052, 3042, 3023, 3022, 3005, 2997, 2962, 2956, 2946, 2915, 2904, 2911, 2863, 2866, 2849, 2824, 2816, 2802, 2786, 2748, 2747, 2754, 2728, 2729, 2723, 2712, 2715, 2697, 2698, 2691, 2672, 2666, 2645, 2643, 2642, 2632, 2634, 2610, 2598, 2591, 2571, 2575, 2567, 2517, 2507, 2492, 2496, 2498, 2477, 2481, 2473, 2464, 2430, 2414, 2422, 2406, 2399, 2376, 2378, 2355, 2364, 2348, 2341, 2324, 2322, 2287, 2281, 2283, 2265, 2245, 2237, 2229, 2224, 2225, 2208, 2201, 2192, 2193, 2188, 2179, 2169, 2154, 2147, 2130, 2136, 2115, 2109, 2103, 2085, 2068, 2059, 2026, 2018, 2014, 2015, 2016, 2006, 1980, 1978, 1969, 1960, 1966, 1936, 1927, 1915, 1906, 1872, 1856, 1841, 1829, 1820, 1814, 1800, 1791, 1784, 1789, 1774, 1772, 1749, 1752, 1741, 1727, 1715, 1707, 1704, 1697, 1688, 1695, 1680, 1671, 1658, 1654, 1646, 1642, 1639, 1631, 1619, 1617, 1607, 1595, 1594, 1584, 1578, 1566, 1554, 1504, 1489, 1479, 1464, 1462, 1459, 1452, 1448, 1435, 1431, 1413, 1400, 1365, 1350, 1347, 1336, 1340, 1342, 1338, 1305, 1303, 1291, 1276, 1275, 1256, 1258, 1254, 1252, 1228, 1227, 1221, 1200, 1183, 1185, 1154, 1150, 1155, 1148, 1122, 1114, 1107, 1097, 1099, 1064, 1056, 1060, 1035, 1038, 1025, 1031, 998, 996, 992, 984, 971, 966, 960, 953, 956, 929, 917, 899, 905, 892, 843, 838, 820, 806, 794, 781, 779, 771, 769, 752, 712, 696, 700, 677, 680, 681, 646, 642, 622, 620, 608, 604, 600, 603, 570, 561, 559, 532, 520, 522, 502, 506, 501, 482, 476, 478, 466, 441, 434, 5, 6, 10, 23, 32, 40, 49, 78, 90, 88, 100, 116, 110, 126, 121, 129, 133, 164, 160, 172, 184, 177, 178, 179, 199, 198, 211, 216, 231, 229, 226, 227, 251, 252, 244, 283, 299, 298, 294, 295, 319, 315, 360, 367, 375, 383, 384, 400, 418, 432]",4.6,4589.929999999993,4594.529999999993
4996,"[446, 4995, 4947, 4940, 4974, 4934, 4922, 4983, 4966, 4885, 4895, 4910, 4887, 4826, 4845, 4840, 4854, 4821, 4832, 4787, 4781, 4792, 4782, 4778, 4800, 4807, 4758, 4743, 4748, 4728, 4733, 4694, 4699, 4659, 4670, 4661, 4649, 4651, 4640, 4650, 4637, 4569, 4553, 4552, 4531, 4517, 4512, 4524, 4501, 4472, 4466, 4448, 4427, 4431, 4416, 4383, 4379, 4360, 4334, 4347, 4325, 4311, 4320, 4317, 4304, 4305, 4303, 4286, 4288, 4283, 4272, 4263, 4226, 4225, 4221, 4216, 4183, 4181, 4164, 4155, 4156, 4144, 4140, 4130, 4138, 4105, 4103, 4096, 4088, 4093, 4071, 4060, 4058, 4055, 4053, 4054, 4041, 4032, 4029, 4030, 4019, 4014, 4008, 4004, 3987, 3966, 3965, 3951, 3941, 3937, 3935, 3933, 3916, 3920, 3904, 3880, 3874, 3881, 3863, 3822, 3796, 3780, 3765, 3763, 3751, 3753, 3748, 3738, 3729, 3724, 3723, 3713, 3697, 3688, 3677, 3682, 3671, 3670, 3622, 3609, 3617, 3602, 3599, 3560, 3543, 3531, 3538, 3539, 3508, 3498, 3472, 3466, 3454, 3461, 3453, 3446, 3450, 3447, 3434, 3432, 3413, 3412, 3407, 3406, 3396, 3395, 3344, 3331, 3283, 3269, 3262, 3254, 3236, 3209, 3206, 3202, 3204, 3200, 3190, 3195, 3188, 3156, 3142, 3133, 3139, 3115, 3118, 3103, 3104, 3106, 3098, 3081, 3067, 3058, 3066, 3012, 3017, 3000, 3001, 2997, 2977, 2969, 2929, 2922, 2925, 2917, 2912, 2920, 2911, 2907, 2900, 2884, 2886, 2887, 2878, 2841, 2814, 2820, 2811, 2784, 2770, 2761, 2755, 2747, 2751, 2752, 2733, 2712, 2697, 2696, 2693, 2668, 2671, 2659, 2653, 2635, 2636, 2621, 2620, 2614, 2617, 2615, 2603, 2595, 2590, 2593, 2570, 2557, 2556, 2558, 2543, 2544, 2545, 2537, 2525, 2528, 2519, 2517, 2518, 2495, 2476, 2477, 2469, 2465, 2447, 2411, 2404, 2395, 2377, 2356, 2309, 2290, 2282, 2280, 2258, 2257, 2252, 2250, 2230, 2222, 2217, 2208, 2202, 2204, 2162, 2156, 2146, 2125, 2121, 2114, 2115, 2112, 2092, 2088, 2062, 2066, 2061, 2033, 2028, 2024, 2022, 2016, 2006, 1989, 1994, 1972, 1976, 1961, 1954, 1958, 1941, 1946, 1945, 1934, 1935, 1887, 1890, 1876, 1850, 1835, 1833, 1831, 1826, 1828, 1827, 1807, 1789, 1782, 1759, 1757, 1756, 1748, 1750, 1741, 1742, 1726, 1729, 1706, 1701, 1702, 1692, 1683, 1674, 1660, 1651, 1637, 1633, 1622, 1620, 1610, 1597, 1587, 1580, 1583, 1572, 1562, 1558, 1531, 1538, 1528, 1506, 1496, 1483, 1473, 1466, 1461, 1452, 1456, 1454, 1436, 1404, 1386, 1389, 1379, 1377, 1375, 1367, 1359, 1348, 1338, 1316, 1312, 1299, 1296, 1284, 1285, 1271, 1259, 1249, 1227, 1225, 1224, 1219, 1209, 1197, 1195, 1184, 1187, 1167, 1135, 1128, 1113, 1100, 1109, 1090, 1097, 1088, 1086, 1080, 1068, 1063, 1051, 1049, 1036, 1039, 1032, 1033, 1024, 1020, 1014, 1015, 1006, 1001, 988, 986, 963, 958, 928, 901, 882, 864, 850, 848, 832, 812, 819, 802, 782, 766, 762, 757, 749, 741, 690, 686, 664, 661, 663, 622, 618, 624, 619, 602, 604, 593, 589, 595, 582, 581, 557, 519, 508, 513, 472, 469, 450, 449, 457, 441, 445, 14, 28, 35, 31, 44, 52, 71, 81, 86, 95, 88, 102, 98, 108, 112, 135, 131, 128, 140, 160, 172, 169, 166, 175, 184, 189, 209, 217, 216, 220, 242, 243, 240, 234, 253, 261, 273, 280, 301, 345, 348, 353, 363, 374, 413, 416, 426, 439, 433, 440]",8.12,4594.529999999993,4602.649999999993
4997,"[592, 4953, 4958, 4919, 4948, 4967, 4930, 4995, 4916, 4961, 4861, 4870, 4899, 4867, 4875, 4876, 4886, 4830, 4838, 4845, 4828, 4807, 4802, 4756, 4768, 4746, 4771, 4727, 4717, 4737, 4729, 4693, 4678, 4673, 4681, 4635, 4650, 4592, 4596, 4582, 4583, 4548, 4534, 4531, 4536, 4512, 4519, 4491, 4480, 4489, 4452, 4430, 4428, 4412, 4419, 4417, 4410, 4388, 4387, 4363, 4373, 4358, 4321, 4318, 4308, 4304, 4306, 4284, 4282, 4273, 4251, 4243, 4246, 4241, 4215, 4206, 4202, 4198, 4193, 4184, 4175, 4178, 4161, 4167, 4170, 4165, 4155, 4147, 4121, 4119, 4122, 4109, 4106, 4097, 4081, 4082, 4085, 4065, 4062, 4051, 4046, 3996, 3985, 3988, 3979, 3978, 3974, 3969, 3958, 3939, 3896, 3895, 3885, 3865, 3863, 3847, 3816, 3803, 3800, 3784, 3751, 3740, 3736, 3739, 3721, 3720, 3718, 3716, 3715, 3706, 3701, 3699, 3681, 3661, 3624, 3591, 3598, 3595, 3583, 3581, 3584, 3579, 3565, 3559, 3555, 3532, 3521, 3468, 3456, 3448, 3432, 3418, 3412, 3394, 3393, 3384, 3376, 3371, 3359, 3355, 3328, 3326, 3322, 3311, 3299, 3286, 3279, 3259, 3260, 3249, 3247, 3240, 3246, 3230, 3233, 3221, 3217, 3207, 3202, 3188, 3169, 3172, 3148, 3135, 3125, 3084, 3074, 3077, 3072, 3071, 3061, 3054, 3009, 2978, 2956, 2931, 2921, 2922, 2927, 2870, 2844, 2837, 2839, 2814, 2820, 2819, 2804, 2797, 2776, 2781, 2769, 2750, 2739, 2742, 2727, 2723, 2725, 2705, 2695, 2680, 2669, 2672, 2649, 2656, 2630, 2620, 2619, 2611, 2605, 2602, 2604, 2593, 2581, 2588, 2564, 2565, 2560, 2559, 2558, 2546, 2537, 2521, 2530, 2510, 2492, 2483, 2490, 2484, 2476, 2470, 2461, 2459, 2455, 2452, 2448, 2417, 2422, 2406, 2370, 2374, 2339, 2318, 2317, 2314, 2275, 2257, 2250, 2253, 2247, 2246, 2231, 2206, 2184, 2177, 2139, 2110, 2105, 2091, 2088, 2078, 2066, 2069, 2058, 2050, 2047, 2042, 2028, 2033, 2015, 2008, 2000, 1976, 1966, 1951, 1954, 1958, 1956, 1943, 1909, 1886, 1872, 1878, 1860, 1855, 1856, 1857, 1827, 1830, 1803, 1810, 1806, 1811, 1801, 1800, 1769, 1768, 1773, 1757, 1732, 1730, 1722, 1721, 1699, 1702, 1674, 1667, 1653, 1652, 1642, 1645, 1614, 1606, 1577, 1569, 1552, 1545, 1537, 1529, 1516, 1518, 1517, 1519, 1509, 1500, 1487, 1483, 1471, 1459, 1435, 1413, 1409, 1408, 1412, 1401, 1374, 1381, 1354, 1356, 1350, 1353, 1339, 1329, 1320, 1298, 1278, 1280, 1267, 1275, 1262, 1246, 1233, 1207, 1196, 1191, 1187, 1139, 1128, 1116, 1082, 1085, 1061, 1068, 1058, 1057, 1060, 1050, 1035, 1025, 1015, 1010, 998, 1004, 992, 990, 977, 957, 958, 943, 901, 860, 866, 837, 817, 810, 802, 782, 774, 764, 759, 753, 737, 728, 717, 689, 676, 645, 647, 651, 644, 616, 610, 597, 0, 1, 6, 2, 27, 38, 44, 77, 87, 94, 118, 119, 120, 135, 151, 160, 167, 173, 184, 188, 199, 198, 223, 232, 231, 245, 258, 289, 290, 294, 345, 352, 362, 384, 389, 414, 423, 458, 478, 482, 505, 520, 534, 541, 539, 549, 548, 562, 573, 581]",8.6,4594.529999999993,4603.129999999994
4998,"[366, 4989, 4976, 4946, 4987, 4995, 4980, 4928, 4978, 4923, 4952, 4924, 4884, 4858, 4886, 4881, 4894, 4864, 4863, 4915, 4869, 4912, 4906, 4866, 4825, 4848, 4856, 4853, 4776, 4775, 4764, 4759, 4772, 4761, 4732, 4722, 4726, 4685, 4691, 4707, 4670, 4666, 4659, 4642, 4640, 4649, 4629, 4624, 4569, 4566, 4529, 4534, 4509, 4506, 4495, 4507, 4497, 4473, 4466, 4465, 4461, 4451, 4455, 4436, 4414, 4409, 4415, 4379, 4385, 4349, 4355, 4361, 4348, 4314, 4308, 4316, 4311, 4301, 4259, 4266, 4253, 4234, 4240, 4224, 4221, 4223, 4214, 4205, 4197, 4185, 4174, 4155, 4141, 4135, 4122, 4112, 4107, 4113, 4096, 4101, 4081, 4070, 4069, 4072, 4062, 4047, 4039, 4022, 4017, 4004, 3995, 3982, 3974, 3966, 3960, 3949, 3936, 3911, 3910, 3896, 3891, 3879, 3855, 3853, 3844, 3833, 3834, 3839, 3808, 3800, 3770, 3757, 3758, 3737, 3739, 3738, 3735, 3733, 3720, 3723, 3696, 3688, 3678, 3669, 3659, 3656, 3640, 3637, 3621, 3599, 3598, 3597, 3593, 3576, 3572, 3560, 3564, 3562, 3551, 3539, 3513, 3499, 3482, 3474, 3471, 3457, 3456, 3433, 3423, 3417, 3409, 3410, 3397, 3382, 3362, 3327, 3291, 3277, 3276, 3267, 3252, 3249, 3245, 3236, 3230, 3227, 3210, 3203, 3199, 3192, 3194, 3190, 3188, 3171, 3160, 3154, 3149, 3134, 3128, 3122, 3085, 3084, 3076, 3054, 3032, 3007, 2983, 2961, 2949, 2921, 2927, 2911, 2891, 2870, 2863, 2857, 2859, 2846, 2835, 2807, 2792, 2791, 2776, 2782, 2783, 2768, 2747, 2744, 2738, 2717, 2724, 2691, 2684, 2686, 2683, 2672, 2666, 2665, 2654, 2649, 2647, 2642, 2634, 2628, 2619, 2609, 2618, 2614, 2604, 2594, 2596, 2584, 2571, 2568, 2558, 2544, 2537, 2525, 2528, 2504, 2505, 2496, 2492, 2484, 2480, 2476, 2470, 2471, 2464, 2457, 2458, 2430, 2431, 2427, 2426, 2407, 2406, 2409, 2402, 2397, 2380, 2349, 2345, 2350, 2344, 2309, 2299, 2298, 2288, 2287, 2277, 2271, 2257, 2262, 2261, 2265, 2256, 2233, 2219, 2211, 2216, 2210, 2206, 2201, 2187, 2169, 2170, 2150, 2141, 2103, 2104, 2108, 2084, 2064, 2052, 2034, 2021, 2011, 2000, 1989, 1950, 1954, 1947, 1941, 1940, 1948, 1928, 1929, 1881, 1888, 1864, 1869, 1850, 1841, 1839, 1826, 1794, 1755, 1737, 1718, 1709, 1702, 1690, 1667, 1622, 1608, 1593, 1587, 1582, 1569, 1560, 1568, 1552, 1549, 1557, 1519, 1509, 1501, 1494, 1471, 1464, 1465, 1455, 1454, 1449, 1437, 1436, 1425, 1428, 1417, 1406, 1404, 1396, 1378, 1372, 1344, 1352, 1336, 1340, 1326, 1327, 1313, 1306, 1312, 1304, 1278, 1249, 1245, 1232, 1233, 1205, 1204, 1196, 1188, 1162, 1167, 1161, 1154, 1144, 1136, 1120, 1096, 1077, 1075, 1073, 1080, 1068, 1066, 1062, 1047, 1045, 1034, 1025, 1031, 1017, 1005, 995, 983, 971, 972, 968, 969, 939, 942, 931, 918, 909, 902, 889, 879, 869, 850, 851, 843, 825, 815, 816, 804, 810, 792, 795, 786, 788, 770, 735, 729, 703, 674, 673, 667, 640, 644, 638, 635, 630, 627, 613, 597, 591, 595, 594, 590, 588, 578, 584, 570, 551, 530, 514, 515, 517, 507, 478, 477, 468, 457, 437, 428, 420, 410, 411, 404, 393, 390, 5, 16, 26, 35, 42, 39, 48, 51, 82, 87, 80, 89, 97, 102, 107, 105, 118, 136, 128, 143, 154, 159, 157, 163, 166, 193, 202, 198, 212, 205, 208, 213, 228, 238, 237, 244, 261, 266, 290, 287, 289, 299, 306, 308, 320, 315, 318, 324, 345, 357]",9.66,4606.609999999992,4616.269999999992
4999,"[446, 4978, 4990, 4942, 4933, 4957, 4925, 4948, 4980, 4962, 4998, 4985, 4943, 4935, 4950, 4907, 4877, 4888, 4893, 4857, 4852, 4836, 4839, 4807, 4808, 4799, 4778, 4811, 4776, 4772, 4743, 4745, 4731, 4708, 4684, 4691, 4700, 4670, 4648, 4594, 4606, 4589, 4579, 4577, 4565, 4563, 4510, 4502, 4505, 4488, 4469, 4466, 4449, 4434, 4432, 4399, 4403, 4404, 4400, 4407, 4384, 4377, 4378, 4375, 4363, 4373, 4350, 4359, 4334, 4339, 4325, 4321, 4320, 4319, 4309, 4284, 4285, 4270, 4263, 4233, 4240, 4214, 4210, 4211, 4193, 4164, 4171, 4153, 4141, 4133, 4110, 4100, 4097, 4091, 4094, 4078, 4086, 4074, 4061, 4063, 4039, 4043, 4028, 4033, 4002, 3970, 3979, 3961, 3965, 3967, 3968, 3952, 3951, 3924, 3909, 3897, 3892, 3886, 3888, 3891, 3873, 3880, 3859, 3824, 3814, 3801, 3802, 3783, 3758, 3763, 3753, 3745, 3736, 3744, 3718, 3722, 3723, 3720, 3706, 3711, 3707, 3680, 3671, 3659, 3651, 3645, 3638, 3616, 3613, 3603, 3604, 3583, 3576, 3572, 3555, 3541, 3533, 3517, 3516, 3502, 3498, 3483, 3484, 3462, 3464, 3454, 3446, 3451, 3429, 3394, 3365, 3373, 3331, 3326, 3319, 3311, 3315, 3280, 3259, 3246, 3236, 3215, 3190, 3179, 3176, 3175, 3168, 3162, 3159, 3151, 3157, 3137, 3126, 3122, 3113, 3117, 3103, 3101, 3072, 3070, 3066, 3048, 3057, 3055, 3052, 3040, 3033, 3030, 3022, 3019, 3028, 3001, 2992, 2995, 2981, 2982, 2961, 2966, 2955, 2954, 2922, 2913, 2917, 2920, 2892, 2894, 2895, 2885, 2876, 2871, 2860, 2844, 2839, 2819, 2802, 2786, 2783, 2737, 2739, 2719, 2725, 2689, 2682, 2671, 2654, 2649, 2640, 2625, 2627, 2612, 2615, 2589, 2568, 2553, 2554, 2557, 2521, 2526, 2518, 2516, 2510, 2509, 2499, 2491, 2475, 2467, 2458, 2455, 2450, 2443, 2433, 2424, 2430, 2427, 2406, 2413, 2411, 2389, 2346, 2347, 2336, 2335, 2316, 2319, 2308, 2297, 2305, 2288, 2285, 2286, 2276, 2261, 2264, 2224, 2211, 2206, 2200, 2201, 2193, 2157, 2134, 2136, 2119, 2111, 2112, 2118, 2095, 2063, 2068, 2056, 2041, 2029, 2012, 2015, 1999, 2001, 2006, 1998, 1993, 1983, 1895, 1884, 1880, 1871, 1863, 1866, 1849, 1840, 1837, 1797, 1798, 1801, 1786, 1782, 1772, 1753, 1715, 1701, 1686, 1694, 1648, 1637, 1621, 1579, 1576, 1566, 1563, 1549, 1542, 1544, 1527, 1528, 1519, 1507, 1497, 1491, 1484, 1479, 1461, 1458, 1459, 1432, 1428, 1408, 1411, 1404, 1401, 1354, 1356, 1313, 1301, 1274, 1272, 1264, 1234, 1223, 1225, 1210, 1203, 1200, 1178, 1161, 1144, 1133, 1138, 1115, 1086, 1073, 1049, 999, 1003, 976, 947, 952, 914, 909, 901, 900, 884, 841, 846, 838, 839, 832, 816, 795, 785, 774, 771, 766, 753, 754, 737, 730, 707, 701, 690, 692, 676, 670, 637, 635, 634, 621, 622, 607, 590, 592, 578, 568, 569, 547, 542, 511, 515, 503, 492, 477, 473, 450, 57, 50, 78, 79, 101, 116, 115, 113, 120, 122, 123, 130, 131, 151, 172, 166, 169, 190, 186, 200, 213, 217, 226, 246, 248, 261, 257, 273, 264, 276, 275, 285, 302, 303, 327, 325, 342, 354, 375, 385, 396, 399, 392, 393, 401, 415, 420, 439, 435, 448]",4.12,4616.269999999992,4620.389999999992

compute_critical_path.cypher

CALL gds.dag.longestPath.stream("g", {relationshipWeightProperty: "expected_time"})
YIELD targetNode as target, totalCost, path, costs
WITH target AS last_activity, totalCost AS critical_time, path, costs
ORDER BY critical_time DESC LIMIT 1
RETURN path

compute_critical_path_in_activity_dependency_dag.cypher

CALL gds.dag.longestPath.stream("g", {relationshipWeightProperty: "expected_time"})
YIELD targetNode as target, totalCost
WITH gds.util.asNode(target) AS activity_bound, totalCost AS critical_time
CALL {
    WITH activity_bound, critical_time
    SET activity_bound.critical_time = critical_time
} IN TRANSACTIONS OF 10000 ROWS

get_full_activity_planning.cypher

MATCH (a:Activity)
RETURN a.name AS activity,
    [(a)-[:DEPENDS_ON]->(b)|b.name] AS dependencies,
    a.expected_time AS expected_time,
    a.critical_start AS planned_start,
    a.critical_end AS planned_end
ORDER BY activity ASC

ingest_random_dag.cypher

:param n => 10_000;
:param density => 0.1;

UNWIND range(0,$n-1) AS ix
CREATE (:Activity {name:ix, expected_time: round(10.00 * (0.01+rand()), 2)});

MATCH (a:Activity), (b:Activity WHERE b.name>a.name)
CALL {
    WITH a, b
    WITH a, b
    WHERE rand() < $density
    CREATE (a)<-[:DEPENDS_ON]-(b)
} IN TRANSACTIONS OF 10000 ROWS;

ingest_wikipedia_gantt.cypher

CREATE (a:Activity {name: 1, expected_time: 4.00}),
       (b:Activity {name: 2, expected_time: 5.33}),
       (c:Activity {name: 3, expected_time: 5.17}),
       (d:Activity {name: 4, expected_time: 6.33}),
       (e:Activity {name: 5, expected_time: 5.17}),
       (f:Activity {name: 6, expected_time: 4.50}),
       (g:Activity {name: 7, expected_time: 5.17});

MATCH (a:Activity {name: 1}), (c:Activity {name: 3})
MERGE (c)-[:DEPENDS_ON]->(a);
MATCH (a:Activity {name: 1}), (d:Activity {name: 4})
MERGE (d)-[:DEPENDS_ON]->(a);
MATCH (b:Activity {name: 2}), (e:Activity {name: 5})
MERGE (e)-[:DEPENDS_ON]->(b);
MATCH (c:Activity {name: 3}), (e:Activity {name: 5})
MERGE (e)-[:DEPENDS_ON]->(c);
MATCH (d:Activity {name: 4}), (f:Activity {name: 6})
MERGE (f)-[:DEPENDS_ON]->(d);
MATCH (e:Activity {name: 5}), (g:Activity {name: 7})
MERGE (g)-[:DEPENDS_ON]->(e);

neo4j_query_table_data_2023-10-27.csv

project_in_memory_dag.cypher

MATCH (a:ActivityEnd|ActivityStart)
OPTIONAL MATCH (a)-[r:ACTIVITY]->(b)
WITH gds.graph.project("g", a, b, {relationshipProperties: r {.expected_time}}) AS g
RETURN g

refactor_to_edge_weighted_dag.cypher

MATCH (a:Activity)
CALL {
WITH a
  CREATE (s:ActivityStart {name:a.name})
  CREATE (e:ActivityEnd {name:a.name})
  CREATE (a)-[:HAS_START]->(s)
  CREATE (a)-[:HAS_END]->(e)
  CREATE (s)-[:ACTIVITY {expected_time: a.expected_time}]->(e)
} IN TRANSACTIONS OF 10000 ROWS;

MATCH (end)<-[:HAS_END]-(first:Activity)<-[:DEPENDS_ON]-(second:Activity)-[:HAS_START]->(start)
CALL {
  WITH end, start
  CREATE (end)-[:ACTIVITY {expected_time:0.0}]->(start)
} IN TRANSACTIONS OF 10000 ROWS;

write_critical_bounds_to_activities.cypher

MATCH p=(s:ActivityStart)<--(a:Activity)-->(e:ActivityEnd)
CALL {
    WITH s, a, e
    SET a.critical_start = s.critical_time,
    a.critical_end = e.critical_time
} IN TRANSACTIONS OF 10000 ROWS;