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 ×
    Week 12 ×
    Week 13 ×
    Week 14 ×
    Auditor 1
    🚗
    7
    32
    25
    46
    36
    3
    9
    19
    28
    Auditor 2
    🚗
    4
    44
    30
    50
    53
    6
    52
    5
    47
    48
    Auditor 3
    🚗
    29
    38
    0
    45
    14
    15
    Auditor 4
    🚗
    10
    16
    26
    34
    41
    51
    Auditor 5
    🚗
    11
    49
    2
    12
    13
    17
    18
    23
    24
    31
    33
    35
    40
    42
    43
    Auditor 6
    🚗
    22
    37
    1
    20
    39
    8
    21
    27
    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
    RHI0000014581 OX4 2JY South East Simple 0
    RHI0000008070 OX18 4EX South East Simple 0
    RHI0000010031 CA15 8RX North West Simple 1
    RHI0000004984 DG5 4PG Scotland Simple 1
    RHI0000003399 LD8 2PR Wales Simple 2
    RHI0000020369 LD1 6EU Wales Simple 2
    RHI0000001127 LD7 1NY Wales Simple 2
    RHI0000006327 PH22 1QB Scotland Simple 3
    RHI0000007786 PH26 3HR Scotland Simple 3
    RHI0000000776 PH21 1NE Scotland Simple 3
    RHI0000023411 NP16 6RB Wales Simple 4
    RHI0000009527 BS3 4EB South West Simple 4
    RHI0000022794 SA62 3QU Wales Simple 5
    RHI0000000023 SA71 5PD Wales Simple 5
    RHI0000002834 SA19 8NL Wales Simple 6
    RHI0000014028 SA14 6SP Wales Simple 6
    RHI0000018401 KY16 8NA Scotland Simple 7
    RHI0000014772 KY15 7UQ Scotland Simple 7
    RHI0000020654 KY1 3AQ Scotland Simple 7
    RHI0000016360 DL11 7EX North East Simple 8
    RHI0000012289 DL8 5LA North East Simple 8
    RHI0000010323 DL11 6RS North East Simple 8
    RHI0000013541 TD11 3NE Scotland Simple 9
    RHI0000021561 NE71 6BZ North East Simple 9
    RHI0000010001 CV7 8EB West Midlands Simple 10
    RHI0000022233 B78 3AU West Midlands Simple 10
    RHI0000004898 HR6 0NS West Midlands Simple 11
    RHI0000021133 HR1 3QG West Midlands Simple 11
    RHI0000015831 NG32 2LA East Midlands Simple 12
    RHI0000008857 NG33 4LF East Midlands Simple 12
    RHI0000004274 LL16 4SU Wales Simple 13
    RHI0000023773 LL16 5LN Wales Simple 13
    RHI0000020399 LL16 5NS Wales Simple 13
    RHI0000025393 LU7 0EE East Simple 14
    RHI0000011867 NR17 1UW East Simple 15
    RHI0000009293 NR16 1AY East Simple 15
    RHI0000020206 BB9 9XG North West Simple 16
    RHI0000029271 BL0 0HH North West Simple 16
    RHI0000013717 L40 1UH North West Simple 17
    RHI0000017762 PR4 6XS North West Simple 17
    RHI0000016546 HU11 4ND Yorkshire Simple 18
    RHI0000028747 HU18 1RF Yorkshire Simple 18
    RHI0000026755 AB42 5BR Scotland Simple 19
    RHI0000020292 AB42 4JD Scotland Simple 19
    RHI0000001911 AB41 8RB Scotland Simple 19
    RHI0000024601 DG11 1RY Scotland Simple 20
    RHI0000007003 DG12 6RR Scotland Simple 20
    RHI0000005867 DG12 5EZ Scotland Simple 20
    RHI0000013817 LA19 5XB North West Simple 21
    RHI0000008224 G76 0QA Scotland Simple 22
    RHI0000018924 WF9 3NR Yorkshire Simple 23
    RHI0000025367 SY5 9JU Wales Simple 24
    RHI0000007605 NE19 1HD North East Simple 25
    RHI0000011367 TF6 6PQ West Midlands Simple 26
    RHI0000027384 PA21 2BS Scotland Simple 27
    RHI0000022023 AB31 4AN Scotland Simple 28
    RHI0000026362 RH5 5SN South East Simple 29
    RHI0000003125 SA13 2PE Wales Simple 30
    RHI0000022669 SY23 4QU Wales Simple 31
    RHI0000012429 EH27 8DS Scotland Simple 32
    RHI0000011870 TA21 0HP South West Simple 33
    RHI0000003316 TA4 1NG South West Simple 33
    RHI0000022558 EX16 9DU South West Simple 33
    RHI0000002890 DN10 6EZ East Midlands Simple 34
    RHI0000009673 DN17 3JE East Midlands Simple 34
    RHI0000013212 CH3 8LE North West Simple 35
    RHI0000000205 TD9 7AD Scotland Simple 36
    RHI0000008696 KA19 8HQ Scotland Simple 37
    RHI0000001262 SL6 3LJ South East Simple 38
    RHI0000000139 CA4 8PG North West Simple 39
    RHI0000014831 ST14 7LE West Midlands Simple 40
    RHI0000029799 WS15 3JQ West Midlands Simple 40
    RHI0000003562 PE21 7AQ East Simple 41
    RHI0000015208 YO14 0PH Yorkshire Simple 42
    RHI0000008242 LA3 3FH North West Simple 43
    RHI0000026419 CF23 5EZ Wales Simple 44
    RHI0000024506 BN17 5ET South East Simple 45
    RHI0000022913 NE63 8QZ North East Simple 46
    RHI0000007055 PL15 8NS South West Simple 47
    RHI0000005094 EX36 3LE South West Simple 48
    RHI0000025844 WR4 9XH West Midlands Simple 49
    RHI0000027348 TA11 6JD South West Simple 50
    RHI0000007615 YO43 4RE Yorkshire Simple 51
    RHI0000018232 SA33 6XG Wales Simple 52
    RHI0000009061 DT10 2BG South West Simple 53