Spreadsheet: 38884d1237054169-how-to-auto-increase-a-monthly-range-and-addition-formula-based-on-dates-if-criteria-new-work-in-progress
Sheet: Sheet1

Do not delete these columns. If we get a new consultant, add their intitials in the next blank row in the column headed by the team they will be part of.
NEVER DELETE ANY INITIALS (even if someone left 6 months ago, deleting their initials will mean the months in which they made placements will display the
wrong billing figures, and any 'year to date' figures will be wrong as a result.
LONDON | MANCHESTER | BRISTOL | CAMBRIDGE | BIRMINGHAM
London | [NAME] | Bristol | Cambridge
AP |  | GT | EO
MG |  | KD
KJ |  | PC
 |  | AXP
IF A NEW CONSULTANT JOINS, YOU MUST ADD THEIR INITIALS TO ROWS 1-20, AND INCLUDE THEM IN THE BILLINGS IN COLUMN Y
Job ID | Confirm Date | [NAME] | Candidate [NAME] | Flat fee or % | Salary | Fee | Candidate who was replaced/ BLOW OUT | 1st consultant involved | % |  | 2nd consultant involved | % |  | 3rd consultant involved | % |  | Start date | Invoice date | [NAME] | PO Reference | Candidate Source
2009-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO NOT DELETE - used to calculate placements made this month |  |  |  |  |  |  |  |  | DO NOT DELETE - used to calculate invoices raised this month
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | Value of billings actually |  |  | Value of billings actually |  |  | candidate contact |  |  | client contact
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | invoiced this month |  |  | made this month |  |  | WIP billings |  |  | WIP billings
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | MG | 0 |  | MG | 0 |  | MG | 0 |  | MG | 0 |  | MG | 0 |  | MG | 0 |  | MG | 0 |  | MG | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | AP | 0 |  | AP | 0 |  | AP | 0 |  | AP | 0 |  | AP | 0 |  | AP | 0 |  | AP | 0 |  | AP | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | KJ | 0 |  | KJ | 0 |  | KJ | 0 |  | KJ | 0 |  | KJ | 0 |  | KJ | 0 |  | KJ | 0 |  | KJ | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | EO | 0 |  | EO | 0 |  | EO | 0 |  | EO | 0 |  | EO | 0 |  | EO | 0 |  | EO | 0 |  | EO | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | GT | 0 |  | GT | 0 |  | GT | 0 |  | GT | 0 |  | GT | 0 |  | GT | 0 |  | GT | 0 |  | GT | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | PC | 0 |  | PC | 0 |  | PC | 0 |  | PC | 0 |  | PC | 0 |  | PC | 0 |  | PC | 0 |  | PC | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | KD | 0 |  | KD | 0 |  | KD | 0 |  | KD | 0 |  | KD | 0 |  | KD | 0 |  | KD | 0 |  | KD | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | AXP | 0 |  | AXP | 0 |  | AXP | 0 |  | AXP | 0 |  | AXP | 0 |  | AXP | 0 |  | AXP | 0 |  | AXP | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Do not delete - used to work out summary boxes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | candidate contact column |  |  | client contact column |  |  | 3rd consultant involved
 | 2009-03-01 00:00:00 |  | CURRENT MONTH |  |  |  |  |  |  |  | YEAR TO DATE TARGET |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00 |  |  | Placements made during |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00 |  |  | 2009-03-01 00:00:00
 |  |  |  | % of |  |  | Actual |  | Target |  |  | % of |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the course of this month
 |  | Actual | Target | target |  |  |  |  |  |  |  | target |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual |  |  | Actual
 | London | 0 |  | 0% |  | London | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | London | 0 |  | London | 0 |  | London | 0 |  | London | 0
 | Bristol | 0 |  | 0% |  | Bristol | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bristol | 0 |  | Bristol | 0 |  | Bristol | 0 |  | Bristol | 0
 | [NAME] | 0 |  | 0% |  | [NAME] | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 |  | [NAME] | 0 |  | [NAME] | 0 |  | [NAME] | 0
 | Cambridge | 0 |  | 0% |  | Cambridge | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cambridge | 0 |  | Cambridge | 0 |  | Cambridge | 0 |  | Cambridge | 0
 | spare | 0 |  | 0% |  | spare | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | spare | 0 |  | spare | 0 |  | spare | 0 |  | spare | 0
 | Misc |  |  | 0% |  | Misc |  |  |  |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Misc |  |  | Misc |  |  | Misc |  |  | Misc
 | Total | 0 | 0 | 0% |  | Total | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | 0 |  | Total |  |  | Total |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If you ever click on the cells in the 'actual' columns above, do not press enter, you must always press ctrl-shift-enter
To create a new 'block' for the next month, highlight the above 'block' from the top left purple cell to the cell in column AM on this row, and copy. Select the cell immediately below this row in column A, and select paste special, and select 'format'. Then click paste (having the same cell selected).
2009-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO NOT DELETE - used to calculate placements made this month |  |  |  |  |  |  |  |  | DO NOT DELETE - used to calculate invoices raised this month
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | Value of billings actually |  |  | Value of billings actually |  |  | candidate contact |  |  | client contact
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | invoiced this month |  |  | made this month |  |  | WIP billings |  |  | WIP billings
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | 2009-04-01 00:00:00 |  |  | 2009-04-01 00:00:00 |  |  | 2009-04-01 00:00:00 |  |  | 2009-04-01 00:00:00 |  |  | 2009-04-01 00:00:00 |  |  | 2009-04-01 00:00:00 |  |  | 2009-04-01 00:00:00 |  |  | 2009-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual |  |  | Actual
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | MG | 0 |  | MG | 0 |  | MG | 0 |  | MG | 0 |  | MG | 0 |  | MG | 0 |  | MG | 0 |  | MG | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | AP | 0 |  | AP | 0 |  | AP | 0 |  | AP | 0 |  | AP | 0 |  | AP | 0 |  | AP | 0 |  | AP | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | KJ | 0 |  | KJ | 0 |  | KJ | 0 |  | KJ | 0 |  | KJ | 0 |  | KJ | 0 |  | KJ | 0 |  | KJ | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | EO | 0 |  | EO | 0 |  | EO | 0 |  | EO | 0 |  | EO | 0 |  | EO | 0 |  | EO | 0 |  | EO | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | GT | 0 |  | GT | 0 |  | GT | 0 |  | GT | 0 |  | GT | 0 |  | GT | 0 |  | GT | 0 |  | GT | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | PC | 0 |  | PC | 0 |  | PC | 0 |  | PC | 0 |  | PC | 0 |  | PC | 0 |  | PC | 0 |  | PC | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | KD | 0 |  | KD | 0 |  | KD | 0 |  | KD | 0 |  | KD | 0 |  | KD | 0 |  | KD | 0 |  | KD | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  | AXP | 0 |  | AXP | 0 |  | AXP | 0 |  | AXP | 0 |  | AXP | 0 |  | AXP | 0 |  | AXP | 0 |  | AXP | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0 |  | 100 | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Do not delete - used to work out summary boxes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | candidate contact column |  |  | client contact column |  |  | 3rd consultant involved
 | 2009-04-01 00:00:00 |  | CURRENT MONTH |  |  |  |  |  |  |  | YEAR TO DATE TARGET |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00 |  |  | 2009-04-01 00:00:00 |  |  | 2009-04-01 00:00:00
 |  |  |  | % of |  |  | Actual |  | Target |  |  | % of
 |  | Actual | Target | target |  |  |  |  |  |  |  | target |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual |  |  | Actual
 | London | 0 |  | 0% |  | London | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | London | 0 |  | London | 0 |  | London | 0 |  | London | 0
 | Bristol | 0 |  | 0% |  | Bristol | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bristol | 0 |  | Bristol | 0 |  | Bristol | 0 |  | Bristol | 0
 | [NAME] | 0 |  | 0% |  | [NAME] | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0 |  | [NAME] | 0 |  | [NAME] | 0 |  | [NAME] | 0
 | Cambridge | 0 |  | 0% |  | Cambridge | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cambridge | 0 |  | Cambridge | 0 |  | Cambridge | 0 |  | Cambridge | 0
 | spare | 0 |  | 0% |  | spare | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | spare | 0 |  | spare | 0 |  | spare | 0 |  | spare | 0
 | Misc |  |  | 0% |  | Misc |  |  |  |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Misc |  |  | Misc |  |  | Misc |  |  | Misc
 | Total | 0 | 0 | 0% |  | Total | 0 |  | 0 |  |  | 0% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | 0 |  | Total |  |  | Total |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If you ever click on the cells in the 'actual' columns above, do not press enter, you must always press ctrl-shift-enter
To create a new 'block' for the next month, highlight the above 'block' from the top left purple cell to the cell in column AM on this row, and copy. Select the cell immediately below this row in column A, and select paste special, and select 'format'. Then click paste (having the same cell selected).