Spreadsheet: 101391d1299534613-excel-function-for-calculating-hours-in-a-week-for-several-employees-production-report
Sheet: Mar 7-13

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