Spreadsheet: 768860d1645175153-leadtime-for-jobs-based-on-available-resources-leadtime-for-jobs-based-on-available-resources
Sheet: Sheet3

Table 1
Worker category | Number of workers in worker category | Available from date | Available to date | Percent capacity when available % | FTEs
Worker category 1 | 1 | 2007-01-01 00:00:00 | 2030-01-01 00:00:00 | 1
Worker category 2 | 2 | 2022-02-17 00:00:00 | 2022-04-15 00:00:00 | 0.4
Worker category 3 | 1 | 2022-08-06 00:00:00 | 2023-10-15 00:00:00 | 0.9
Worker category 4 | 3 | 2024-12-04 00:00:00 | 2025-03-30 00:00:00 | 0.3
Worker category 5 | 1 | 2022-03-03 00:00:00 | 2022-05-17 00:00:00 | 1
Table 2
Availability from date
Availability to date
Worker category 1
Worker category 2
Worker category 3
Worker category 4
Worker category 5
SUM FTEs (Full time employees) in period
Networkdays in period
Duration if all available resources divide work between them [net work days]
Table 3
Jobs | Man days required pr. job (net work days) | Start date of job | Duration if all available resources divide work between them [net work days] | Duration if all available resources divide work between them [gross days] | Finish date of job
Job 1 | 200 | 2022-02-22 00:00:00
 |  | 2022-02-23 00:00:00 | 1.8 |  | 3.6
 |  | 2022-02-24 00:00:00 | 1.8 |  | 5.4
 |  | 2022-02-25 00:00:00 | 1.8 |  | 7.2
 |  | 2022-02-28 00:00:00 | 1.8 |  | 9
 |  | 2022-03-01 00:00:00 | 1.8 |  | 10.8
 |  | 2022-03-02 00:00:00 | 1.8 |  | 12.6
 |  | 2022-03-03 00:00:00 | 2.8 |  | 15.4
 |  | 2022-03-04 00:00:00 | 2.8 |  | 18.2
 |  | 2022-03-07 00:00:00 | 2.8 |  | 21
 |  | 2022-03-08 00:00:00 | 2.8 |  | 23.8
 |  | 2022-03-09 00:00:00 | 2.8 |  | 26.6
 |  | 2022-03-10 00:00:00 | 2.8 |  | 29.40000000000001
 |  | 2022-03-11 00:00:00 | 2.8 |  | 32.2
 |  | 2022-03-14 00:00:00 | 2.8 |  | 35
 |  | 2022-03-15 00:00:00 | 2.8 |  | 37.8
 |  | 2022-03-16 00:00:00 | 2.8 |  | 40.59999999999999
 |  | 2022-03-17 00:00:00 | 2.8 |  | 43.39999999999999
 |  | 2022-03-18 00:00:00 | 2.8 |  | 46.19999999999999
 |  | 2022-03-21 00:00:00 | 2.8 |  | 48.99999999999999
 |  | 2022-03-22 00:00:00 | 2.8 |  | 51.79999999999998
 |  | 2022-03-23 00:00:00 | 2.8 |  | 54.59999999999998
 |  | 2022-03-24 00:00:00 | 2.8 |  | 57.39999999999998
 |  | 2022-03-25 00:00:00 | 2.8 |  | 60.19999999999997
 |  | 2022-03-28 00:00:00 | 2.8 |  | 62.99999999999997
 |  | 2022-03-29 00:00:00 | 2.8 |  | 65.79999999999997
 |  | 2022-03-30 00:00:00 | 2.8 |  | 68.59999999999997
 |  | 2022-03-31 00:00:00 | 2.8 |  | 71.39999999999996
 |  | 2022-04-01 00:00:00 | 2.8 |  | 74.19999999999996
 |  | 2022-04-04 00:00:00 | 2.8 |  | 76.99999999999996
 |  | 2022-04-05 00:00:00 | 2.8 |  | 79.79999999999995
 |  | 2022-04-06 00:00:00 | 2.8 |  | 82.59999999999995
 |  | 2022-04-07 00:00:00 | 2.8 |  | 85.39999999999995
 |  | 2022-04-08 00:00:00 | 2.8 |  | 88.19999999999995
 |  | 2022-04-11 00:00:00 | 2.8 |  | 90.99999999999994
 |  | 2022-04-12 00:00:00 | 2.8 |  | 93.79999999999994
 |  | 2022-04-13 00:00:00 | 2.8 |  | 96.59999999999994
 |  | 2022-04-14 00:00:00 | 2.8 |  | 99.39999999999993
 |  | 2022-04-15 00:00:00 | 2.8 |  | 102.1999999999999
 |  | 2022-04-18 00:00:00 | 2 |  | 104.1999999999999
 |  | 2022-04-19 00:00:00 | 2 |  | 106.1999999999999
 |  | 2022-04-20 00:00:00 | 2 |  | 108.1999999999999
 |  | 2022-04-21 00:00:00 | 2 |  | 110.1999999999999
 |  | 2022-04-22 00:00:00 | 2 |  | 112.1999999999999
 |  | 2022-04-25 00:00:00 | 2 |  | 114.1999999999999
 |  | 2022-04-26 00:00:00 | 2 |  | 116.1999999999999
 |  | 2022-04-27 00:00:00 | 2 |  | 118.1999999999999
 |  | 2022-04-28 00:00:00 | 2 |  | 120.1999999999999
 |  | 2022-04-29 00:00:00 | 2 |  | 122.1999999999999
 |  | 2022-05-02 00:00:00 | 2 |  | 124.1999999999999
 |  | 2022-05-03 00:00:00 | 2 |  | 126.1999999999999
 |  | 2022-05-04 00:00:00 | 2 |  | 128.1999999999999
 |  | 2022-05-05 00:00:00 | 2 |  | 130.1999999999999
 |  | 2022-05-06 00:00:00 | 2 |  | 132.1999999999999
 |  | 2022-05-09 00:00:00 | 2 |  | 134.1999999999999
 |  | 2022-05-10 00:00:00 | 2 |  | 136.1999999999999
 |  | 2022-05-11 00:00:00 | 2 |  | 138.1999999999999
 |  | 2022-05-12 00:00:00 | 2 |  | 140.1999999999999
 |  | 2022-05-13 00:00:00 | 2 |  | 142.1999999999999
 |  | 2022-05-16 00:00:00 | 2 |  | 144.1999999999999
 |  | 2022-05-17 00:00:00 | 2 |  | 146.1999999999999
 |  | 2022-05-18 00:00:00 | 1 |  | 147.1999999999999
 |  | 2022-05-19 00:00:00 | 1 |  | 148.1999999999999
 |  | 2022-05-20 00:00:00 | 1 |  | 149.1999999999999
 |  | 2022-05-23 00:00:00 | 1 |  | 150.1999999999999
 |  | 2022-05-24 00:00:00 | 1 |  | 151.1999999999999
 |  | 2022-05-25 00:00:00 | 1 |  | 152.1999999999999
 |  | 2022-05-26 00:00:00 | 1 |  | 153.1999999999999
 |  | 2022-05-27 00:00:00 | 1 |  | 154.1999999999999
 |  | 2022-05-30 00:00:00 | 1 |  | 155.1999999999999
 |  | 2022-05-31 00:00:00 | 1 |  | 156.1999999999999
 |  | 2022-06-01 00:00:00 | 1 |  | 157.1999999999999
 |  | 2022-06-02 00:00:00 | 1 |  | 158.1999999999999
 |  | 2022-06-03 00:00:00 | 1 |  | 159.1999999999999
 |  | 2022-06-06 00:00:00 | 1 |  | 160.1999999999999
 |  | 2022-06-07 00:00:00 | 1 |  | 161.1999999999999
 |  | 2022-06-08 00:00:00 | 1 |  | 162.1999999999999
 |  | 2022-06-09 00:00:00 | 1 |  | 163.1999999999999
 |  | 2022-06-10 00:00:00 | 1 |  | 164.1999999999999
 |  | 2022-06-13 00:00:00 | 1 |  | 165.1999999999999
 |  | 2022-06-14 00:00:00 | 1 |  | 166.1999999999999
 |  | 2022-06-15 00:00:00 | 1 |  | 167.1999999999999
 |  | 2022-06-16 00:00:00 | 1 |  | 168.1999999999999
 |  | 2022-06-17 00:00:00 | 1 |  | 169.1999999999999
 |  | 2022-06-20 00:00:00 | 1 |  | 170.1999999999999
 |  | 2022-06-21 00:00:00 | 1 |  | 171.1999999999999
 |  | 2022-06-22 00:00:00 | 1 |  | 172.1999999999999
 |  | 2022-06-23 00:00:00 | 1 |  | 173.1999999999999
 |  | 2022-06-24 00:00:00 | 1 |  | 174.1999999999999
 |  | 2022-06-27 00:00:00 | 1 |  | 175.1999999999999
 |  | 2022-06-28 00:00:00 | 1 |  | 176.1999999999999
 |  | 2022-06-29 00:00:00 | 1 |  | 177.1999999999999
 |  | 2022-06-30 00:00:00 | 1 |  | 178.1999999999999
 |  | 2022-07-01 00:00:00 | 1 |  | 179.1999999999999
 |  | 2022-07-04 00:00:00 | 1 |  | 180.1999999999999
 |  | 2022-07-05 00:00:00 | 1 |  | 181.1999999999999
 |  | 2022-07-06 00:00:00 | 1 |  | 182.1999999999999
 |  | 2022-07-07 00:00:00 | 1 |  | 183.1999999999999
 |  | 2022-07-08 00:00:00 | 1 |  | 184.1999999999999
 |  | 2022-07-11 00:00:00 | 1 |  | 185.1999999999999
 |  | 2022-07-12 00:00:00 | 1 |  | 186.1999999999999
 |  | 2022-07-13 00:00:00 | 1 |  | 187.1999999999999
 |  | 2022-07-14 00:00:00 | 1 |  | 188.1999999999999
 |  | 2022-07-15 00:00:00 | 1 |  | 189.1999999999999
 |  | 2022-07-18 00:00:00 | 1 |  | 190.1999999999999
 |  | 2022-07-19 00:00:00 | 1 |  | 191.1999999999999
 |  | 2022-07-20 00:00:00 | 1 |  | 192.1999999999999
 |  | 2022-07-21 00:00:00 | 1 |  | 193.1999999999999
 |  | 2022-07-22 00:00:00 | 1 |  | 194.1999999999999
 |  | 2022-07-25 00:00:00 | 1 |  | 195.1999999999999
 |  | 2022-07-26 00:00:00 | 1 |  | 196.1999999999999
 |  | 2022-07-27 00:00:00 | 1 |  | 197.1999999999999
 |  | 2022-07-28 00:00:00 | 1 |  | 198.1999999999999
 |  | 2022-07-29 00:00:00 | 1 |  | 199.1999999999999
 |  | 2022-08-01 00:00:00 | 1 |  | 200.1999999999999
 |  | 2022-08-02 00:00:00 | 1 |  | 201.1999999999999
 |  | 2022-08-03 00:00:00 | 1 |  | 202.1999999999999
 |  | 2022-08-04 00:00:00 | 1 |  | 203.1999999999999
 |  | 2022-08-05 00:00:00 | 1 |  | 204.1999999999999
 |  | 2022-08-08 00:00:00 | 1.9 |  | 206.0999999999999
 |  | 2022-08-09 00:00:00 | 1.9 |  | 207.9999999999999
 |  | 2022-08-10 00:00:00 | 1.9 |  | 209.8999999999999
 |  | 2022-08-11 00:00:00 | 1.9 |  | 211.8
 |  | 2022-08-12 00:00:00 | 1.9 |  | 213.7
 |  | 2022-08-15 00:00:00 | 1.9 |  | 215.6
 |  | 2022-08-16 00:00:00 | 1.9 |  | 217.5
 |  | 2022-08-17 00:00:00 | 1.9 |  | 219.4
 |  | 2022-08-18 00:00:00 | 1.9 |  | 221.3
 |  | 2022-08-19 00:00:00 | 1.9 |  | 223.2
 |  | 2022-08-22 00:00:00 | 1.9 |  | 225.1
 |  | 2022-08-23 00:00:00 | 1.9 |  | 227
 |  | 2022-08-24 00:00:00 | 1.9 |  | 228.9
 |  | 2022-08-25 00:00:00 | 1.9 |  | 230.8
 |  | 2022-08-26 00:00:00 | 1.9 |  | 232.7
 |  | 2022-08-29 00:00:00 | 1.9 |  | 234.6
 |  | 2022-08-30 00:00:00 | 1.9 |  | 236.5
 |  | 2022-08-31 00:00:00 | 1.9 |  | 238.4
 |  | 2022-09-01 00:00:00 | 1.9 |  | 240.3
 |  | 2022-09-02 00:00:00 | 1.9 |  | 242.2
 |  | 2022-09-05 00:00:00 | 1.9 |  | 244.1000000000001
 |  | 2022-09-06 00:00:00 | 1.9 |  | 246.0000000000001
 |  | 2022-09-07 00:00:00 | 1.9 |  | 247.9000000000001
 |  | 2022-09-08 00:00:00 | 1.9 |  | 249.8000000000001
 |  | 2022-09-09 00:00:00 | 1.9 |  | 251.7000000000001
 |  | 2022-09-12 00:00:00 | 1.9 |  | 253.6000000000001
 |  | 2022-09-13 00:00:00 | 1.9 |  | 255.5000000000001
 |  | 2022-09-14 00:00:00 | 1.9 |  | 257.4000000000001
 |  | 2022-09-15 00:00:00 | 1.9 |  | 259.3000000000001
 |  | 2022-09-16 00:00:00 | 1.9 |  | 261.2
 |  | 2022-09-19 00:00:00 | 1.9 |  | 263.1
 |  | 2022-09-20 00:00:00 | 1.9 |  | 265
 |  | 2022-09-21 00:00:00 | 1.9 |  | 266.9
 |  | 2022-09-22 00:00:00 | 1.9 |  | 268.8
 |  | 2022-09-23 00:00:00 | 1.9 |  | 270.6999999999999
 |  | 2022-09-26 00:00:00 | 1.9 |  | 272.5999999999999
 |  | 2022-09-27 00:00:00 | 1.9 |  | 274.4999999999999
 |  | 2022-09-28 00:00:00 | 1.9 |  | 276.3999999999999
 |  | 2022-09-29 00:00:00 | 1.9 |  | 278.2999999999998
 |  | 2022-09-30 00:00:00 | 1.9 |  | 280.1999999999998
 |  | 2022-10-03 00:00:00 | 1.9 |  | 282.0999999999998
 |  | 2022-10-04 00:00:00 | 1.9 |  | 283.9999999999998
 |  | 2022-10-05 00:00:00 | 1.9 |  | 285.8999999999997
 |  | 2022-10-06 00:00:00 | 1.9 |  | 287.7999999999997
 |  | 2022-10-07 00:00:00 | 1.9 |  | 289.6999999999997
 |  | 2022-10-10 00:00:00 | 1.9 |  | 291.5999999999997
 |  | 2022-10-11 00:00:00 | 1.9 |  | 293.4999999999997
 |  | 2022-10-12 00:00:00 | 1.9 |  | 295.3999999999996
 |  | 2022-10-13 00:00:00 | 1.9 |  | 297.2999999999996
 |  | 2022-10-14 00:00:00 | 1.9 |  | 299.1999999999996
 |  | 2022-10-17 00:00:00 | 1.9 |  | 301.0999999999996
 |  | 2022-10-18 00:00:00 | 1.9 |  | 302.9999999999995
 |  | 2022-10-19 00:00:00 | 1.9 |  | 304.8999999999995
 |  | 2022-10-20 00:00:00 | 1.9 |  | 306.7999999999995
 |  | 2022-10-21 00:00:00 | 1.9 |  | 308.6999999999995
 |  | 2022-10-24 00:00:00 | 1.9 |  | 310.5999999999995
 |  | 2022-10-25 00:00:00 | 1.9 |  | 312.4999999999994
 |  | 2022-10-26 00:00:00 | 1.9 |  | 314.3999999999994
 |  | 2022-10-27 00:00:00 | 1.9 |  | 316.2999999999994
 |  | 2022-10-28 00:00:00 | 1.9 |  | 318.1999999999994
 |  | 2022-10-31 00:00:00 | 1.9 |  | 320.0999999999993
 |  | 2022-11-01 00:00:00 | 1.9 |  | 321.9999999999993
 |  | 2022-11-02 00:00:00 | 1.9 |  | 323.8999999999993
 |  | 2022-11-03 00:00:00 | 1.9 |  | 325.7999999999993
 |  | 2022-11-04 00:00:00 | 1.9 |  | 327.6999999999992
 |  | 2022-11-07 00:00:00 | 1.9 |  | 329.5999999999992
 |  | 2022-11-08 00:00:00 | 1.9 |  | 331.4999999999992
 |  | 2022-11-09 00:00:00 | 1.9 |  | 333.3999999999992
 |  | 2022-11-10 00:00:00 | 1.9 |  | 335.2999999999992
 |  | 2022-11-11 00:00:00 | 1.9 |  | 337.1999999999991
 |  | 2022-11-14 00:00:00 | 1.9 |  | 339.0999999999991
 |  | 2022-11-15 00:00:00 | 1.9 |  | 340.9999999999991
 |  | 2022-11-16 00:00:00 | 1.9 |  | 342.8999999999991
 |  | 2022-11-17 00:00:00 | 1.9 |  | 344.799999999999
 |  | 2022-11-18 00:00:00 | 1.9 |  | 346.699999999999
 |  | 2022-11-21 00:00:00 | 1.9 |  | 348.599999999999
 |  | 2022-11-22 00:00:00 | 1.9 |  | 350.499999999999
 |  | 2022-11-23 00:00:00 | 1.9 |  | 352.399999999999
 |  | 2022-11-24 00:00:00 | 1.9 |  | 354.2999999999989
 |  | 2022-11-25 00:00:00 | 1.9 |  | 356.1999999999989
 |  | 2022-11-28 00:00:00 | 1.9 |  | 358.0999999999989