Spreadsheet: 117981d1313325672-how-to-extract-info-from-one-column-based-on-anothers-data-copy-of-weekly-planner-generic-template
Sheet: Planner by Team Member

team weekly planner |  |  |  |  | Scroll down for FTE variance |  |  | 8 aug  2011  - 12 aug 2011
day |  | mon |  | tues |  | wed |  | thu |  | fri
leave
loaned
name |  | team | hrs | team | hrs | team | hrs | team | hrs | team | hrs
borrowed
name |  | function | hrs | function | hrs | function | hrs | function | hrs | function | hrs
Member A |  | Job 5
name |  | function | hrs | function | hrs | function | hrs | function | hrs | function | hrs
member ab | member ab | Job 32 |  | Job 6 |  | Job 11 |  | Job 21 |  | Job 8
 | member ab | Job 21
 | member ab
 | member ab
total | member ab |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member ad | member ad | Job 33 |  |  |  | Job 36 |  | Job 77 |  | Job 14
 | member ad | Job 21
 | member ad
 | member ad
total | member ad |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member tr | member tr | Job 3 |  |  |  |  |  |  |  | Job 3
 | member tr
 | member tr
 | member tr
total | member tr |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member ds | member ds | Job 12 |  |  |  |  |  |  |  | Job 4
 | member ds
 | member ds
 | member ds
total | member ds |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member pz | member pz | Job 12
 | member pz | Job 32
 | member pz | Job 8
 | member pz
total | member pz |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member ss | member ss | Job 55
 | member ss
 | member ss
 | member ss
total | member ss |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member bn | member bn | Job 11
 | member bn | Job 4
 | member bn
 | member bn
total | member bn |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member we | member we | Job 7
 | member we
 | member we
 | member we
total | member we |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member tr | member tr | Job 6
 | member tr
 | member tr
 | member tr
total | member tr |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member gf | member gf | Job 43
 | member gf
 | member gf
 | member gf
total | member gf |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member vc | member vc | Job 4
 | member vc | Job 51
 | member vc
 | member vc
total | member vc |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member sd | member sd | Job 36
 | member sd | Job 14
 | member sd
 | member sd
total | member sd |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
member zx | member zx | Job 77
 | member zx
 | member zx
 | member zx
total |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
function |  | total hrs | fte | total hrs | fte | total hrs | fte | total hrs | fte | total hrs | fte
Job 3 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 4 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 5 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 6 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 7 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 8 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 12 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 14 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 21 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 31 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 33 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 36 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 43 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 51 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 55 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Job 77 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
totals |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
hours required |  | 54.9 |  | 53.9 |  | 53.9 |  | 59.9 |  | 51.9
total diverted time |  | 9 |  | 13 |  | 11 |  | 10 |  | 14
hours + diverted |  | 63.9 |  | 66.9 |  | 64.9 |  | 69.9 |  | 65.9
variance hours |  | -63.9 |  | -66.9 |  | -64.9 |  | -69.9 |  | -65.9
variance fte |  | -7.9875 |  | -8.3625 |  | -8.1125 |  | -8.7375 |  | -8.2375
Need