Green Transition Auditor Schedule Manager

The auditor schedule manager allows users to users to manage auditor assignments and optimise routes generated by the modelling solution.
  • Users can drag and drop clusters between auditors/weeks; add weeks with "Add Week" button or remove empty weeks.
  • Save changes to update the schedule and map, then use "Re-Optimise Weekly Routes" to recalculate optimal daily visits.
  • Users can also export to Excel and view additional site details below.
  • Toggle between Cluster View and Site View using the switch.
    • Before exporting to excel remember to run the weekly re-optimisation!

    Cluster View Site View
    Auditor
    Week 1 ×
    Week 2 ×
    Week 3 ×
    Week 4 ×
    Week 5 ×
    Week 6 ×
    Week 7 ×
    Week 8 ×
    Week 9 ×
    Week 10 ×
    Week 11 ×
    Alexis
    🚗
    15
    22
    42
    18
    35
    25
    31
    32
    Todd
    🚗
    8
    10
    7
    0
    1
    2
    5
    6
    9
    Archie
    🚗
    17
    14
    13
    16
    12
    36
    37
    20
    23
    34
    41
    28
    Ana
    🚗
    39
    4
    Rahul
    🚗
    21
    33
    11
    40
    3
    19
    38
    26
    27
    29
    24
    30
    Blue popup icons show the starting locations of each auditor.
    Weeks can be hidden/shown using the filter buttons, or the show all layers button.
    Each coloured circle shows a cluster group for a week and the auditor assigned to it. Clusters can also be clicked within the table to show/hide them on the map.

    Site Information

    ID Postcode Region Complexity Cluster
    RHI0000019840 SA14 8YP Wales Simple 0
    RHI0000013777 SA31 2AF Wales Simple 0
    RHI0000005449 SA16 0TH Wales Simple 0
    RHI0000001092 GL18 1EB South West Simple 1
    RHI0000028532 HR8 2LJ West Midlands Simple 1
    RHI0000011016 HR8 1JX West Midlands Simple 1
    RHI0000021164 HR2 6LB West Midlands Simple 2
    RHI0000020433 HR2 6NH West Midlands Simple 2
    RHI0000024391 HR2 6BQ West Midlands Simple 2
    RHI0000007447 HR6 9DF West Midlands Simple 3
    RHI0000007722 HR6 9DH West Midlands Simple 3
    RHI0000006203 HR6 0HY West Midlands Simple 3
    RHI0000033377 HR6 9LA West Midlands Simple 3
    RHI0000009513 SY7 9BH Wales Simple 4
    RHI0000007200 LD1 5SW Wales Simple 5
    RHI0000007199 LD1 5SW Wales Simple 5
    RHI0000021377 EX15 3PX South West Simple 6
    RHI0000020060 EX15 3BX South West Simple 6
    RHI0000009404 NP7 9DN Wales Simple 7
    RHI0000007637 NP15 1PX Wales Simple 7
    RHI0000006826 NP44 2BZ Wales Simple 7
    RHI0000009880 SA43 1PP Wales Simple 8
    RHI0000009562 PL13 2LX South West Simple 9
    RHI0000010696 BA22 8RE South West Simple 10
    RHI0000009735 GL20 8HY South West Simple 11
    RHI0000007641 NN6 7QA East Midlands Simple 12
    RHI0000018932 NN7 2QD East Midlands Simple 12
    RHI0000019050 MK46 4HR South East Simple 12
    RHI0000007432 NN6 7UT East Midlands Simple 12
    RHI0000001542 PE11 3BE East Simple 13
    RHI0000009093 PE11 3BE East Simple 13
    RHI0000000789 PE34 4EX East Simple 13
    RHI0000001256 PE14 9EY East Simple 13
    RHI0000011252 IP33 3RL East Simple 14
    RHI0000002069 IP31 2BG East Simple 14
    RHI0000020431 IP32 7BB East Simple 14
    RHI0000002799 TW18 3AP Unknown Simple 15
    RHI0000021743 RG30 3XA South East Simple 15
    RHI0000009452 PE22 0LR East Simple 16
    RHI0000012245 LN4 4XH East Midlands Simple 16
    RHI0000009660 PE22 9PE East Simple 16
    RHI0000021763 SG9 0EH East Simple 17
    RHI0000019074 SG10 6JJ East Simple 17
    RHI0000002788 PO6 1RR South East Simple 18
    RHI0000014265 NG32 1RB East Midlands Simple 19
    RHI0000001194 NR10 4DB East Simple 20
    RHI0000006930 DE6 3EL East Midlands Simple 21
    RHI0000009861 DE6 3DJ East Midlands Simple 21
    RHI0000008480 DE6 2FE East Midlands Simple 21
    RHI0000008802 DA15 7HD Unknown Simple 22
    RHI0000019216 IP12 2TW East Simple 23
    RHI0000022871 CH7 6LG North West Simple 24
    RHI0000022872 LL18 6DE Wales Simple 24
    RHI0000023144 CH5 3PJ North West Simple 24
    RHI0000023413 CH65 4EQ North West Simple 24
    RHI0000002142 CA6 6DR North West Simple 25
    RHI0000021395 CA10 1HA North West Simple 25
    RHI0000020505 CA5 7DA North West Simple 25
    RHI0000020398 CA11 9PF North West Simple 25
    RHI0000012256 SY4 1ES Wales Simple 26
    RHI0000009114 SY4 3HE Wales Simple 26
    RHI0000009999 SY3 8EU Wales Simple 26
    RHI0000012253 SY4 1ES Wales Simple 26
    RHI0000009131 SY4 3HE Wales Simple 26
    RHI0000023585 SY21 8JX Wales Simple 27
    RHI0000022226 SY11 4AD Wales Simple 28
    RHI0000026210 SY11 4LP Wales Simple 28
    RHI0000022552 S81 7DJ Yorkshire Simple 29
    RHI0000021592 DN11 0PS East Midlands Simple 29
    RHI0000025767 DN5 7SU East Midlands Simple 29
    RHI0000019615 DN7 6HA East Midlands Simple 29
    RHI0000001801 YO25 9LP Yorkshire Simple 30
    RHI0000022791 YO25 8EG Yorkshire Simple 30
    RHI0000025657 YO25 9LP Yorkshire Simple 30
    RHI0000030579 YO12 4PB Yorkshire Simple 30
    RHI0000006974 YO16 4XE Yorkshire Simple 30
    RHI0000007240 YO8 6EF Yorkshire Simple 31
    RHI0000020227 YO42 4ST Yorkshire Simple 31
    RHI0000006952 DN40 3JY East Midlands Simple 32
    RHI0000006958 DN40 3JY East Midlands Simple 32
    RHI0000020375 HU16 5RX Yorkshire Simple 32
    RHI0000019303 DH6 5NN North East Simple 33
    RHI0000002889 CA11 0LS North West Simple 34
    RHI0000029729 CA11 0LS North West Simple 34
    RHI0000013032 CA12 5RZ North West Simple 34
    RHI0000009988 BL9 6UN North West Simple 35
    RHI0000007079 WN1 2XJ North West Simple 35
    RHI0000030335 PR5 0UE North West Simple 35
    RHI0000007077 WN1 2XJ North West Simple 35
    RHI0000009377 LN8 3YR East Midlands Simple 36
    RHI0000021141 LN8 3YJ East Midlands Simple 36
    RHI0000017920 DN21 4JD East Midlands Simple 36
    RHI0000011791 DN21 4TF East Midlands Simple 36
    RHI0000006982 LN2 2UP East Midlands Simple 37
    RHI0000012127 LN3 5AX East Midlands Simple 37
    RHI0000012126 LN3 5AX East Midlands Simple 37
    RHI0000030022 LL55 4AP Wales Simple 38
    RHI0000022317 TF9 2PG West Midlands Simple 39
    RHI0000011783 TF9 2LW West Midlands Simple 39
    RHI0000018366 CA28 9UR North West Simple 40
    RHI0000007900 CA7 4PA North West Simple 41
    RHI0000022163 PE21 7RY East Simple 42