Spreadsheet: 101397d1299536208-excel-function-for-calculating-hours-in-a-week-for-several-employees-productionreport
Sheet: Mar 7-13

 | [NAME]
Client | Project | Account Manager | Staff | Time | Status | Date |  | Client | Project | Account Manager | Staff | Time | Status | Date
Monday | Monday | Monday | Monday | Monday
RCMP | Troop 7 Top Picks and Burn Disks | Heather | [NAME] | 1 |  | 2011-05-11 00:00:00
SSTC | Annual Report Financials | Jayda | Erin | 2 |  | 2011-05-11 00:00:00
RCMP | Tags for photos | [NAME] | VIctor | 3 |  | 2011-05-11 00:00:00
SHCA | Golf Tourney Registration Form | Jayda | [NAME] | 2 |  | 2011-05-11 00:00:00
RCMP | Tags for Photos | [NAME] | [NAME] | 1 |  | 2011-05-11 00:00:00
RCMP | Tags for Photos | [NAME] | Justin | 1 |  | 2011-05-11 00:00:00
RCMP | Tags for Photos | [NAME] | [NAME] | 1 |  | 2011-05-11 00:00:00
SSTC | APM dry run | Jayda/Andrew | Justin | 2 |  | 2011-05-11 00:00:00
Fairways West | [NAME] | Jayda | Zlatan | 2 |  | 2011-05-11 00:00:00
[NAME] | Create Staff e-mail signatures | [NAME] | Erin | 1 |  | 2011-05-11 00:00:00
RHA | Create Curling Ad for Web | [NAME] | [NAME] | 0.5 |  | 2011-05-11 00:00:00
My Ementor | Name Creative | [NAME] | [NAME] | 1 |  | 2011-05-11 00:00:00
HCSAS | Create 2 new certificates (phone the client) | Zlatan | Zlatan | 0.5 |  | 2011-05-11 00:00:00
Harvard Communities | Complete tradeshow booth | Zlatan | Erin | 1 |  | 2011-05-11 00:00:00
Fairways West | Design big box ad for Leader Post | Zlatan | [NAME] | 0.5 |  | 2011-05-11 00:00:00
Look Matters | Web Server DRP Plan | Zlatan | Victor | 2 |  | 2011-05-11 00:00:00
Sun Dale | Website [NAME] | Zlatan | Victor | 2 |  | 2011-05-11 00:00:00
Look Matters | Unblock Zlatan's IP 64.201.213.169 | Zlatan | Victor | 0.5 |  | 2011-05-11 00:00:00
Rochdale Crossing | Splash Page | Jayda | [NAME] | 1 |  | 2011-05-11 00:00:00
Rochdale Crossing | Get Content Organized | Jayda | Jayda | 1.5 |  | 2011-05-11 00:00:00
Look Matters | FIX SPREADSHEET | [NAME] | Heather | 2 |  | 2011-05-11 00:00:00
MLW | Edit Top Picks | [NAME] | [NAME] | 2 | Completed | 2011-05-11 00:00:00
Tuesday | Tuesday | Tuesday | Tuesday | Tuesday
SHCA | Meet with [NAME] on Media [NAME] | [NAME] | [NAME] | 1 |  | 2011-05-12 00:00:00
RCMP | insert RCMP dates and change photos as requested in email | [NAME] | [NAME] | 2 |  | 2011-05-12 00:00:00
RCMP | Give frame price to [NAME] | [NAME] | Christine | 2 |  | 2011-05-12 00:00:00
RCMP | Sales book for divisions layout of design prepared | [NAME] | [NAME] | 4 |  | 2011-05-12 00:00:00
SHCA | Proofread Rate Guide Changes | Erin | Jayda | 2 |  | 2011-05-12 00:00:00
dundee | captions into ads | [NAME] | Erin | 2 |  | 2011-05-12 00:00:00
dundee | web coding start | [NAME] | Justin | 4 |  | 2011-05-12 00:00:00
dundee | rumour creative | [NAME] | [NAME] | 1.5 |  | 2011-05-12 00:00:00
sweep | commercial creative w jeremy | [NAME] | [NAME] | 1 |  | 2011-05-12 00:00:00
lux granite | finalize web copy | [NAME] | Justin | 3 |  | 2011-05-12 00:00:00
dundee | weekly lp ads | [NAME] | Erin | 0.5 |  | 2011-05-12 00:00:00
ementor | Create new logo | [NAME] | [NAME] | 1.5 |  | 2011-05-12 00:00:00
[NAME] | [NAME] w coders | [NAME] | Victor | 1 |  | 2011-05-12 00:00:00
robinson | web coder meeting for massive site | [NAME] | Victor | 1 |  | 2011-05-12 00:00:00
Fairways | Design builder and resident newsletters | zlatan | [NAME] | 3 |  | 2011-05-12 00:00:00
Fairways | Finalize radio copy | Zlatan | Jayda | 0.5 |  | 2011-05-12 00:00:00
Fairways | Finalize brochures for printing | Zlatan | Erin | 0.5 |  | 2011-05-12 00:00:00
Harvard Communities | Populate Facebook page for Harvard Communities | Zlatan | [NAME] | 2 |  | 2011-05-12 00:00:00
SHCA | Finalize Content List for eNews | [NAME] | [NAME] |  |  | 2011-05-12 00:00:00
RCMP | Troop 7 Shipping | Heather | [NAME] | 3 |  | 2011-05-12 00:00:00
Rochdale Crossing | Splash Page | Jayda | [NAME] | 1 |  | 2011-05-12 00:00:00
Realty Executive Faith Realty | Business Portrait Photography | Heather | [NAME] | 1 |  | 2011-05-12 00:00:00
Realty Executive Faith Realty | Business Portrait Editing | Heather | [NAME] | 0.5 |  | 2011-05-12 00:00:00
Wednesday | Wednesday | Wednesday | Wednesday | Wednesday
SHCa | Design of Media Kit | [NAME] | [NAME] | 2 |  | 2011-05-13 00:00:00
Brandt Industries | March 9th Shoot | Heather | [NAME] | 3 |  | 2011-05-13 00:00:00
H&B | Editing of video complete | [NAME] | [NAME] | 2 |  | 2011-05-13 00:00:00
RCMP | Tags for Photos | [NAME] | [NAME] | 1 |  | 2011-05-13 00:00:00
RCMP | Tags for Photos | [NAME] | Justin | 1 |  | 2011-05-13 00:00:00
RCMP | Tags for Photos | [NAME] | [NAME] | 1 |  | 2011-05-13 00:00:00
LM | [NAME] and sweaters designed | [NAME] | Christine | 0.5 |  | 2011-05-13 00:00:00
RHA | Heat map and stats pages printed for stayinregina.com | [NAME] | Victor | 1 |  | 2011-05-13 00:00:00
SSTC | Create APM Evite | Jayda | Erin | 1 |  | 2011-05-13 00:00:00
RHA | 2 experience bannerstands | Carl/Erin | Erin | 0.5 |  | 2011-05-13 00:00:00
SHCA | Rate Guide Internal Proof Changes/Ad finsalization | Erin | Erin | 2.5 |  | 2011-05-13 00:00:00
[NAME] | site map | [NAME] | [NAME] | 1 |  | 2011-05-13 00:00:00
lux granite | site sign off and launch | [NAME] | Justin | 2.5 |  | 2011-05-13 00:00:00
Fairways | Create contest materials for Spring Home Show | Zlatan | [NAME] | 2 |  | 2011-05-13 00:00:00
Fairways | Develop campaign for Greenside Terrace | Zlatan | Erin | 0.5 |  | 2011-05-13 00:00:00
Fairways | Develop campaign for Greenside Terrace | Zlatan | [NAME] | 0.5 |  | 2011-05-13 00:00:00
Fairways | Develop campaign for Greenside Terrace | Zlatan | Jayda | 0.5 |  | 2011-05-13 00:00:00
Fairways | Develop campaign for Greenside Terrace | Zlatan | Zlatan | 0.5 |  | 2011-05-13 00:00:00
[NAME] | Work on the website | Zlatan | Justin | 4 |  | 2011-05-13 00:00:00
[NAME] | [NAME] Tickets | Zlatan | [NAME] | 1 |  | 2011-05-13 00:00:00
[NAME] | Track & Trail Discount Card | Zlatan | [NAME] | 0.5 |  | 2011-05-13 00:00:00
[NAME] | Certificate | Zlatan | [NAME] | 0.5 |  | 2011-05-13 00:00:00
Thursday | Thursday | Thursday | Thursday | Thursday
 | [NAME] Holiday
Brandt Industries | March 9th Shoot [NAME] | Heather | [NAME] | 1 |  | 2011-05-14 00:00:00
RHA | Source company to create branded chocolates | [NAME] | Jayda | 0.5 |  | 2011-05-14 00:00:00
SSTC | APM PowerPoint | Jayda | Erin | 2 |  | 2011-05-14 00:00:00
Fairways | Develop campaign for Greenside Terrace | Zlatan | Erin | 4 |  | 2011-05-14 00:00:00
QAM | Website Training | [NAME] | Zlatan | 1 |  | 2011-05-14 00:00:00
Allman | idty package | [NAME] | erin | 3 |  | 2011-05-14 00:00:00
Friday | Friday | Friday | Friday | Friday
H&B | Research how to photograph jewelry using a light cone and try it out | CARL | [NAME] | 1.5 |  | 2011-05-15 00:00:00
LM | install of new western sales sign | [NAME] | [NAME] |  |  | 2011-05-15 00:00:00
[NAME] | Send File to Print (Client Approval) | Christine/Erin | [NAME] | 0.5 |  | 2011-05-15 00:00:00
H+B | Sales kit update design edited with new content | [NAME] | [NAME] |  |  | 2011-05-15 00:00:00
Totals | Totals | Totals | Totals | Totals | Totals
 | Completed | 1 | -0.25
 | WOS | 0 | 0
 | WOC | 0 | 0
 | Feedback | 0 | 0
 | Push | 0 | 0
 | Cancelled | 0 | 0
 | Follow-up | 0 | 0
 | FIRM | 0 | 0
 | Empty | -5 | 1.25
 | Total | -4 | 1
Time Totals | Mon | [NAME] | Wed | Thur | Fri | Week
Erin | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Jon | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Justin | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Victor | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Variables - Don't touch anything in here!
R:Totals | 135
R:Monday | 3
R:Tuesday | 26
R:Wed | 54
R:Thur | 81
R:Fri | 110