Spreadsheet: 93413d1292993629-excel-2007-splitting-checkbox-choice-data-in-pivot-table-2011-objectives-engagement-report
Sheet: Objectives

Account ID | Client Name | Status | Group | Region-Vertical | CA Resource | CA Resource (2) | Sales Rep | [NAME] | Cost | Initial Request Date | Renewal Date | Revenue Expectation | Current Contract Amt | Renewal Amount | Off-cycle Revenue | Initial Objectives | Completed Objectives | Executive Summary | Notes | Modified | Modified By | Item Type | Path
103+393 | Test Data 1 | Current | Fieldsales | Staffing | [NAME] | [NAME] | [NAME] | [NAME] | 0 | 2010-12-20 00:00:00 | 2011-02-02 00:00:00 | Save Revenue | 1000000 | 900000 | 4000 | Acquire new contacts;#Gather information | Better client relationship;#Introduce new product mix | This is an executive summary for upper management. | Anecdotal evidence right here.  Here is some other important information.  We are working to do this as best as we can. | 2010-12-20 12:54:23 | [NAME], [NAME] | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Objectives Report
230-23 | Test Client 2 | Current | Fieldsales | Staffing | [NAME] | [NAME] | [NAME] | [NAME] | 0 | 2011-01-02 00:00:00 | 2011-12-31 00:00:00 | Increase YoY Revenue | 256999 |  | 0 | Increase usage;#Drive better usage;#Acquire new contacts;#Gather information;#Train on brand new product | Off-cycle revenue;#Increase YoY revenue;#Acquire new contacts;#Gather information;#Train on brand new product | Test is doing well. | Anecdote here | 2010-12-17 13:34:15 | [NAME], [NAME] | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Objectives Report
334+3T | new client 2 | Current | Fieldsales | Southeast | [NAME] | [NAME] | new guy | new manager | 0 | 2011-02-01 00:00:00 | 2011-04-01 00:00:00 | Save Revenue | 404043 |  | 0 | Gather information | Gather information | hello | hello run | 2010-12-20 12:16:56 | [NAME], [NAME] | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Objectives Report
393+3t | Client 3 | Complete | Fieldsales | Southeast | [NAME] | [NAME] | [NAME] | [NAME] | 0 | 2010-12-29 00:00:00 | 2011-11-20 00:00:00 | Save Revenue | 400000 |  | 300 | Better client relationship;#Increase usage;#Drive better usage | Better client relationship;#Drive better usage | Testing CA Resources out on this entry | 2 ca resources selected and one selected on ca resource 2 | 2010-12-20 12:50:04 | [NAME], [NAME] | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Objectives Report
4939-39 | Client 4 | Inactive | GAM | Northeast | [NAME] |  | [NAME] | [NAME] | 0 | 2011-01-03 00:00:00 | 2011-02-02 00:00:00 | Increase YoY Revenue;#Gain Off-cycle Revenue;#Product Upgrade | 43000 | 44000 | 2500 | Drive better usage | Drive better usage | Testing without ca resource 2. | testing testing testing | 2010-12-20 12:53:25 | [NAME], [NAME] | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Objectives Report
4a6-444 | new client 1 | Pipeline | GAM | West/NW | [NAME] | [NAME] | west rep | west manag | 0 | 2011-03-01 00:00:00 | 2011-05-01 00:00:00 | Maintain YoY Revenue;#Gain Off-cycle Revenue | 494949 |  | 0 | Drive better usage;#Train on brand new product | Increase YoY revenue;#Increase usage | summing | noting | 2010-12-20 12:18:15 | [NAME], [NAME] | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Objectives Report
548+T5 | client 5 | Current | Telesales | Northeast | [NAME] | [NAME] | Fake Name | Fake Manager | 0 | 2011-01-08 00:00:00 | 2011-03-31 00:00:00 | Product Upgrade | 30000 |  | 50000 | Train on brand new product;#Introduce new product mix | Off-cycle revenue | test test | testing test | 2010-12-20 12:50:08 | [NAME], [NAME] | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Objectives Report
642+39 | client 6 | Pipeline | Fieldsales | Southeast | [NAME] | [NAME] | rep | manager | 0 | 2011-01-29 00:00:00 | 2011-02-01 00:00:00 | Gain Off-cycle Revenue | 50000 | 60000 | 0 | Increase usage;#Drive better usage | Increase usage;#Acquire new contacts | proof | proof | 2010-12-20 13:06:25 | [NAME], [NAME] | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Objectives Report
753+09 | client 7 | Current | Fieldsales | Southeast | [NAME] | [NAME] | rep | manager | 0 | 2011-01-29 00:00:00 | 2011-02-01 00:00:00 | Gain Off-cycle Revenue | 50000 |  | 0 | Increase usage;#Drive better usage | Increase usage;#Acquire new contacts | proof | proof | 2010-12-20 11:51:54 | [NAME], [NAME] | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Objectives Report
999+999 | added client 99 | Pipeline | Fieldsales | Southeast | [NAME] |  | person | manager | 0 | 2011-05-25 00:00:00 | 2011-12-22 00:00:00 | Gain Off-cycle Revenue | 999999 |  | 0 | Increase usage;#Drive better usage | Increase usage;#Acquire new contacts | copy | copy | 2010-12-20 12:36:23 | [NAME], [NAME] | Item | sites/teams/other/Client.Adoption.Team/Lists/2011 Objectives Report