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