Spreadsheet: 101397d1299536208-excel-function-for-calculating-hours-in-a-week-for-several-employees-productionreport
Sheet: Feb 28 - Mar 6

Week of | Feb 28-Mar 6 2010
Client | Project | Account Manager | Staff | Time | Status
Monday | Monday | Monday | Monday | Monday
SHCA | Finalize design of eNewsLetter, have Christine Proofread & Send proof to client | Jess/Jayda | Bri/Christine |  | Completed
SSTC | [NAME] design | Jayda | Erin |  | Completed
SWEEP | Start design of new creative | Jayda | [NAME] |  | Completed
BB | Edit fish and chips and taco in a bag banner with new photo and tag | Erin | [NAME] |  | Completed
LMatters | Design a cover sheet for a saddle stitch uncovery document | [NAME] | [NAME] |  | Push
MLW | OSA contract and [NAME] | [NAME] | [NAME] |  | Completed
[NAME] | New billboard add-on and new billboard mock-up - Send to Laur'lei Silzer | Jess/Zlatan | [NAME] |  | Completed
[NAME] | Send billboard add-on to ID once approved | Jess/Zlatan | [NAME] |  | Completed
SSTC | Annual Report Proof to Theresa | Jess/Jayda | Erin |  | Completed
SHCA | Get final approval on Tabs | Erin | Erin |  | Completed
Altern` | Vis idty guidelines | [NAME] | [NAME] |  | Completed
Altern` | Finalize idty burn cd pkg | [NAME] | [NAME] |  | Completed
Ementor | Name creative meetin w client | [NAME] | [NAME] |  | Completed
Safe | Update/.keep going | [NAME] | Jon |  | Completed
[NAME] | Idty pkg vis idty guidelines | [NAME] | Erin |  | Completed
[NAME] | Burn cd of idty pkg | [NAME] | Erin |  | WOS
EMW | Creative for Office Logo | Zlatan | [NAME] |  | WOS
Fairways | Make changes to the video | Zlatan | Zlatan |  | Completed
Fairways | Work on hockey game event | Zlatan | Zlatan |  | Completed
Trademark Homes | Property Photography Photo  Editing | Heather | [NAME] |  | Completed
Regina Pats | Game Photo Editing | Heather | [NAME] |  | Completed
[NAME] | Troop 7 Grad | Heather | [NAME] |  | Completed
Tuesday | Tuesday | Tuesday | Tuesday | Tuesday
SHCA | Final changes to eNewsletter after Client review and send second proof | Jess/Jayda | Bri/Jayda |  | Completed
HCSAS | Create 2 new certificates | Zlatan | [NAME] |  | WOC
LM | Remove old logo from google places and images | [NAME] | Victor |  | Completed
LM | Change logo on basecamp to new logo | [NAME] | Victor |  | Completed
LM | Staff Bios | Jayda | Jayda |  | Completed
MLW | Offices to go creative | [NAME] | [NAME] |  | Completed
H+B | Editing of video complete | [NAME] | [NAME] |  | Push
LM | Upload Bios | Zlatan | Justin |  | WOS
RHA | [NAME] for RHA | [NAME] | Erin |  | Completed
Allman homes | Creative for idty pkg | [NAME] | [NAME] |  | Completed
Dundee | Rumor creative | [NAME] | [NAME] |  | Completed
SHCA | Send out inside Ad proofs | Erin | Erin |  | Completed
EMW | 8x4 Sign approval | Zlatan | Zlatan |  | Push
Fairways | Design Spring Home Show Booth | Zlatan | Erin |  | Completed
Harvard | Create delay on Tower 3 Const Camera | Zlatan | Victor |  | Completed
H&B | Business Card Design | [NAME] | [NAME] |  | Completed
Wednesday | Wednesday | Wednesday | Wednesday | Wednesday
SHCA | Send out eNewsletter after lunch | Jess/Jayda | Jayda/Justin |  | Completed
RHA | Edits to experiences complete includign sask standard/science centre adn (tentative) Globe theatre | [NAME] | Erin |  | Completed
H+B | Sales kit update design edited with new content | [NAME] | [NAME] |  | Push
CAA | Meeting regarding signage | [NAME] | [NAME] |  | Completed
SSTC | Create Reminder E-vite for online AGM | Jayda | Erin |  | Push
Regina Downtown | Get a start on publication design for Downtown Map | Jess/Jayda | [NAME] |  | Completed
SHCA | Post eNewsLetter to website - Bri create thumbnail | Jess/Jayda | Bri/Justin |  | Completed
SWEEP | Radio Creative | Jayda/Jess | [NAME] |  | Push
RCMP | Give frame price to [NAME] | [NAME] | Carl/Andrew/Keith |  | WOS
RCMP | Find out cost of producing 3,000 and 5000 18 month calendars | [NAME] | [NAME] |  | WOC
Look Matters | Phase 3 Production Spreadsheet ready to demo at Production meeting | [NAME] | Jon |  | Completed
Dundee | Weekly lp ads | [NAME] | Erin |  | Completed
Dundee | New models copy writing | [NAME] | [NAME] |  | Completed
Ementor | Revised idty logo w new name | [NAME] | [NAME] |  | Push
Ementor | Uncovery creative | [NAME] | [NAME] |  | Push
Lux granite | Approve web content | [NAME] | [NAME] |  | Push
Stones edge | Write web content | [NAME] | [NAME] |  | WOS
Lux granite | Pics into site, final changees | [NAME] | Justin |  | Completed
SHCA | Rate guide changes (2.5 hrs) | Erin | Erin |  | Completed
RCMP | Soft launch review for RCMP site | [NAME] | Jon |  | Push
RCMP | 200 + photos ready to be uploaded | [NAME] | [NAME]/david |  | Completed
Harvard | Conference Call with Dennis | Zlatan | Zlatan/Jayda |  | Completed
RSP | web edit of text | [NAME] | Victor |  | Completed
Thursday | Thursday | Thursday | Thursday | Thursday
LM | Sales brochure for SGI created | [NAME] | Heather/Wendy |  | Push
Western sales | Recruitment brochure finalized | [NAME] | Erin |  | Push
RCMP | Launch photo site | [NAME] | Jon |  | Push
LM | [NAME] and sweaters designed | [NAME] | [NAME] |  | Push
RCMP | Sales book for divisions layout of design prepared | [NAME] | [NAME] |  | WOS
Regina Downtown | Get quotes for print pieces - Map, Dining Guide | Jess/Jayda | [NAME] |  | Completed
RCMP | Bomb Squad Shoot | Heather | Keith/David |  | Completed
Allman homes | Idty pkg start | [NAME] | [NAME] |  | Push
Sweep | Commercial creative | [NAME] | [NAME] |  | Push
Lux granite | Launch site | [NAME] | Justin |  | Push
[NAME] | Wed coder meeting creative for site, game plan for large content | [NAME] | [NAME]? |  | Push
Regina Downtown | Photography of Downtown | [NAME] | [NAME] |  | Push
Rochdale Crossing | [NAME] design | Jayda | [NAME] |  | WOS
H&B | compelation video burnt to DVD | [NAME] | Justin |  | Completed
RHA | set up shadow site for RHA | [NAME] | justin |  | Completed
SHA | Team Sask (female) Team Photo Editing | Heather | [NAME] |  | Completed
SHA | Team Sask (Male) Team Photo Editing | Heather | [NAME] |  | Completed
MLW | Sortable content | [NAME] | Jon/Justin |  | Completed
RCMP | Troop 7 Memory Book Production | Heather | [NAME] |  | Completed
MLW | top picks edited | [NAME] | [NAME] |  | Completed
Hotel SK | photo of exterior | [NAME] | [NAME] |  | Completed
H&B | new hire cards and email set up | [NAME] | bri/justin |  | Completed
H&B | poster change and printing | [NAME] | bri |  | Completed
H&B | PK cards ordered and recieved | [NAME] | erin |  | Completed
Western sales | [NAME] LM sent to print | [NAME] | erin |  | Completed
MLW | SEO report prepared | [NAME] | Victor |  | Completed
SSTC | Create AGM notice for web | Erin/Andrew | Erin | 0.5 | Completed
Rochdale Crossing | Secure url's | Jayda | Victor |  | WOS
Friday | Friday | Friday | Friday | Friday
Western sales | Design layout for customer brochure created | [NAME] | Erin |  | WOS
H+B | Legacy book layout created | [NAME] | [NAME] |  | Completed
H+B | Redesign tri fold cards | [NAME] | [NAME] |  | Completed
RHA | Heat map and stats pages printed for stayinregina.com | [NAME] | Jon |  | WOS
MLW | Offices to go logo proofs prepared for internal proof | [NAME] | [NAME] |  | Completed
[NAME] | Kilometer markers | Zlatan | [NAME] |  | Completed
[NAME] | Directional Signage | Zlatan | [NAME] |  | Completed
Symco and Co | Word Template | [NAME] | Victor |  | WOC
LM | Rhymes with "Taint-Man" and involves a power outage | Christine | Christine/Dave |  | Completed
LM | Phase 3 Spreadsheet ready to go | [NAME] | Jon |  | Completed
SSTC | Post AGM Notice on Website | Erin/Andrew | Victor | 0.5 | Completed
SHCA | Update TB Insertion Order Form | Jayda | [NAME] |  | Feedback
SHCA | Create e-news Insertion Order Form | Jayda | [NAME] |  | Feedback
Fairways West | First Drafts of Builder and Resident newsletters | Jayda | Jayda |  | Completed
Totals | Totals | Totals | Totals | Totals | Totals
 | Completed | 69 | -17.25
 | WOS | 10 | -2.5
 | WOC | 3 | -0.75
 | Feedback | 2 | -0.5
 | Push | 19 | -4.75
 | Cancelled | 0 | 0
 | Follow-up | 0 | 0
 | FIRM | 0 | 0
 | Empty | -107 | 26.75
 | 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 | 111
R:Monday | 3
R:Tuesday | 26
R:Wed | 43
R:Thur | 67
R:Fri | 96