Spreadsheet: 677030d1589157427-populate-calendar-and-summary-invercargill-leave
Sheet: Lookup

 | Name | Location | Leave Anniversary Date | Leave amount per year (days) | Leave amount (yearly hours) |  |  |  |  |  |  | Location
 | Name1 | [NAME] |  | 20 |  |  |  |  | Public Holidays |  |  | Dunedin
 | [NAME] | [NAME] |  | 25 |  |  |  |  | New Year's Day | 2020-01-01 00:00:00 |  | Invercargill
 | Name3 | [NAME] |  | 20 |  |  |  |  | Day after New Year's Day | 2020-01-02 00:00:00 |  | [NAME]
 | Name4 | [NAME] |  | 20 |  |  |  |  | Waitangi Day | 2020-02-06 00:00:00 |  | Christchurch
 | Name5 | [NAME] |  | 20 |  |  |  |  | Good Friday | 2020-04-10 00:00:00 |  | Palmerston North
 | Name6 | [NAME] |  | 20 |  |  |  |  | Easter Monday | 2020-04-13 00:00:00 |  | Southdown
 | Name7 | [NAME] |  |  |  |  |  |  | Anzac Day | 2020-04-27 00:00:00 |  | Te Rapa
 | Name8 | Christchurch |  |  |  |  |  |  | Queen's Birthday | 2020-06-01 00:00:00 |  | Timaru
 | Name9 | Christchurch |  |  |  |  |  |  | Labour Day | 2020-10-26 00:00:00 |  | Wellington
 | Name10 | Christchurch |  |  |  |  |  |  | Christmas Day | 2020-12-25 00:00:00
 | Name11 | Christchurch |  |  |  |  |  |  | Boxing Day | 2020-12-26 00:00:00
 | Name12 | Christchurch
 | Name13 | Christchurch
 | Name14 | Christchurch
 | Name15 | Christchurch
 | [NAME] | Christchurch
 | Name17 | Christchurch
 | Name18 | Christchurch
 | Name19 | Christchurch |  |  |  |  |  |  | [NAME]
 | [NAME] | Christchurch |  |  |  |  |  |  | Annual
 | Name21 | Christchurch |  |  |  |  |  |  | Long Service
 | Name22 | Christchurch |  |  |  |  |  |  | Sick
 | Name23 | Christchurch
 | Name24 | Christchurch
 | Name25 | Christchurch
 | Name26 | Christchurch
 | Name27 | Christchurch
 | Name28 | Christchurch
 | Name29 | Christchurch
 | Name30 | Christchurch
 | Name31 | Christchurch
 | Name32 | Christchurch
 | Name33 | Palmerston North
 | [NAME] | Palmerston North
 | Name35 | Palmerston North
 | Name36 | Palmerston North
 | Name37 | Palmerston North
 | Name38 | Palmerston North
 | [NAME] | Palmerston North
 | Name40 | Palmerston North
 | Name41 | Palmerston North
 | Name42 | Palmerston North
 | Name43 | Palmerston North
 | Name44 | Palmerston North
 | Name45 | Palmerston North
 | Name46 | Palmerston North
 | [NAME] | Palmerston North
 | Name48 | Palmerston North
 | Name49 | Southdown
 | Name50 | Southdown
 | Name51 | Southdown
 | [NAME] | Southdown
 | Name53 | Southdown
 | Name54 | Southdown
 | Name55 | Southdown
 | Name56 | Southdown
 | Name57 | Southdown
 | Name58 | Southdown
 | Name59 | Southdown
 | Name60 | Southdown
 | Name61 | Southdown
 | Name62 | Southdown
 | Name63 | Southdown
 | Name64 | Southdown
 | Name65 | Southdown
 | Name66 | Southdown
 | [NAME] | Southdown
 | [NAME] | Southdown
 | Name69 | Southdown
 | Name70 | Southdown
 | Name71 | Southdown
 | Name72 | Southdown
 | [NAME] | Southdown
 | Name74 | Southdown
 | Name75 | Southdown
 | Name76 | Southdown
 | Name77 | Southdown
 | Name78 | Southdown
 | Name79 | Southdown
 | Name80 | Southdown
 | Name81 | Southdown
 | Name82 | Southdown
 | Name83 | Southdown
 | Name84 | Southdown
 | Name85 | Southdown
 | Name86 | Southdown
 | Name87 | Southdown
 | [NAME] | Southdown
 | Name89 | Southdown
 | Name90 | Southdown
 | Name91 | Southdown
 | Name92 | Southdown
 | [NAME] | Southdown
 | [NAME] | Southdown
 | Name95 | Southdown
 | Name96 | Southdown
 | Name97 | Southdown
 | Name98 | Southdown
 | Name99 | Southdown
 | Name100 | Southdown
 | Name101 | Southdown
 | Name102 | Southdown
 | Name103 | Southdown
 | Name104 | Southdown
 | Name105 | Southdown
 | Name106 | Southdown
 | [NAME] | Southdown
 | Name108 | Southdown
 | Name109 | Southdown
 | Name110 | Southdown
 | Name111 | Southdown
 | [NAME] | Southdown
 | Name113 | Southdown
 | Name114 | Southdown
 | Name115 | Southdown
 | Name116 | Southdown
 | [NAME] | Te Rapa
 | Name118 | Te Rapa
 | Name119 | Te Rapa
 | Name120 | Te Rapa
 | Name121 | Te Rapa
 | Name122 | Te Rapa
 | Name123 | Te Rapa
 | [NAME] | Te Rapa
 | Name125 | Te Rapa
 | Name126 | Te Rapa
 | Name127 | Te Rapa
 | Name128 | Te Rapa
 | Name129 | Te Rapa
 | Name130 | Te Rapa
 | Name131 | Te Rapa
 | Name132 | Te Rapa
 | Name133 | Te Rapa
 | Name134 | Te Rapa
 | Name135 | Te Rapa
 | Name136 | Te Rapa
 | Name137 | Te Rapa
 | Name138 | Te Rapa
 | Name139 | Te Rapa
 | Name140 | Te Rapa
 | Name141 | Te Rapa
 | Name142 | Te Rapa
 | Name143 | Timaru
 | Name144 | Timaru
 | [NAME] | Timaru
 | Name146 | Timaru
 | [NAME] | Timaru
 | Name148 | Wellington
 | Name149 | Wellington
 | Name150 | Wellington
 | Name151 | Wellington
 | Name152 | Wellington
 | Name153 | Wellington
 | Name154 | Wellington
 | Name155 | Wellington
 | Name156 | Wellington
 | Name157 | Wellington
 | Name158 | Wellington
 | Name159 | Wellington
 | Name160 | Wellington
 | Name161 | Wellington
 | Name162 | Dunedin
 | Name163 | Dunedin
 | Name164 | Dunedin
 | Name165 | Dunedin
 | Name166 | Invercargill
 | Name167 | Invercargill
 | Name168 | Invercargill
 | Name169 | Invercargill