Spreadsheet: 84517d1284565745-lookup-and-conditional-formatting-test-version-formatting
Sheet: Alliance Tracking Master

Alliance Analysis Tracking |  |  | HOLD | Opt-in | Opt-out | Pending / Committed | Reviewing
Contract Id | Contract Status | [NAME] | Supplier | Effective | Expiration | Category | Resource Council | System Director | Strategy | CITRUS | Multi | SweD | CentWA | To Do / Action Items
PMS40254 | In Progress |  |  | 2008-02-01 00:00:00 | 2010-12-31 00:00:00 | Non-Capital |  |  |  | opt-in | Opt-out | opt-in | opt-out
Future | In Progress |  |  |  |  | Future |  |  |  | opt-out | opt-in | pending | opt-in
Future | In Progress |  |  |  |  |  |  |  |  | opt-out | opt-in | opt-in | opt-out
PSDM002 | Active |  |  | 2005-03-15 00:00:00 | 2013-10-31 00:00:00 | Distribution |  |  |  | opt-out | opt-in | opt-in
PSMS001 | Active |  |  | 2005-07-01 00:00:00 | 2011-01-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
[NAME] | Active |  |  | 2005-07-01 00:00:00 | 2011-01-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PMS70130 | Active |  |  | 2007-07-01 00:00:00 | 2011-12-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PMS70152 | Active |  |  | 2007-10-01 00:00:00 | 2011-12-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PMS70103 | Active |  |  | 2007-10-01 00:00:00 | 2011-12-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PSDM001 | Active |  |  | 2005-01-01 00:00:00 | 2011-12-31 00:00:00 | Distribution |  |  |  | opt-out | opt-in | opt-in
PSBP001 | Active |  |  | 2008-01-01 00:00:00 | 2013-12-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
[NAME] | Active |  |  | 2008-08-01 00:00:00 | 2013-07-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PMS50292 | Active |  |  | 2008-08-01 00:00:00 | 2013-07-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PMS90830 | Active |  |  | 2009-02-15 00:00:00 | 2014-11-30 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PMS01103 | Active |  |  | 2010-01-01 00:00:00 | 2012-12-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PMS01104 | Active |  |  | 2010-01-01 00:00:00 | 2012-12-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PHS0618 | Active |  |  | 2009-12-01 00:00:00 | 2012-11-30 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PMS60231 | Active |  |  | 2010-03-01 00:00:00 | 2011-12-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PMS80550 | In Progress |  |  | 2006-02-01 00:00:00 | 2011-01-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PHS Agreement | In Progress |  |  | 2009-09-01 00:00:00 |  | PHS |  |  |  | opt-out | opt-in | opt-in
PLB40021 | Active |  |  | 2005-09-01 00:00:00 | 2010-03-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
[NAME] | Active |  |  | 2004-09-14 00:00:00 | 2012-05-31 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
PHS Agreement | Active |  |  |  |  | PHS |  |  |  | opt-out | opt-in | opt-in
PDL91000 | Active |  |  | 2010-05-01 00:00:00 | 2014-09-30 00:00:00 | Distribution |  |  |  | opt-out | opt-in | opt-in
PSXR002 | In Progress |  |  | 2007-09-01 00:00:00 | 2011-10-01 00:00:00 | Capital |  |  |  | opt-out | opt-in | opt-in
PCE40141 | In Progress |  |  | 2008-07-01 00:00:00 | 2010-10-31 00:00:00 | Capital |  |  |  | opt-out | opt-in | opt-in
PSXR001 | In Progress |  |  | 2005-02-01 00:00:00 | 2012-06-30 00:00:00 | Capital |  |  |  | opt-out | opt-in | opt-in
PXR50112 | In Progress |  |  | 2006-04-01 00:00:00 | 2010-08-31 00:00:00 | Capital |  |  |  | opt-out | opt-in | opt-in
[NAME] | In Progress |  |  | 2006-04-01 00:00:00 | 2010-08-31 00:00:00 | Capital |  |  |  | opt-out | opt-in | opt-in
PSLB001 | In Progress |  |  | 2005-10-01 00:00:00 | 2010-09-30 00:00:00 | Capital |  |  |  | opt-out | opt-in | opt-in
PSXR003 | In Progress |  |  | 2007-10-01 00:00:00 | 2010-09-30 00:00:00 | Capital |  |  |  | opt-out | opt-in | opt-in
[NAME] (PLB20012) | In Progress |  |  | 2006-11-20 00:00:00 | 2010-09-30 00:00:00 | Non-Capital |  |  |  | opt-out | opt-in | opt-in
Future | In Progress |  |  |  |  | Future |  |  |  | opt-out | opt-in | opt-in
Future | In Progress |  |  |  |  |  |  |  |  | opt-out | opt-in | opt-in
Future | In Progress |  |  |  |  |  |  |  |  | opt-out | opt-in | opt-in
Future | In Progress |  |  |  |  |  |  |  |  | opt-out | opt-in | opt-in
Future | In Progress |  |  |  |  |  |  |  |  |  | opt-in | opt-in
PSVC970 | Active |  |  | 2007-11-01 00:00:00 | 2011-07-14 00:00:00 | Purchased Service |  |  |  |  |  | opt-in
PSSV001 | Active |  |  | 2005-12-19 00:00:00 | 2011-03-31 00:00:00 | Capital |  |  |  |  |  | opt-in
PCE30031 | Active |  |  | 2005-04-01 00:00:00 | 2012-01-31 00:00:00 | Capital |  |  |  |  |  | opt-in
PCE90146 | Active |  |  | 2009-06-01 00:00:00 | 2012-05-31 00:00:00 | Capital |  |  |  |  |  | opt-in
PCE60021 | Active |  |  | 2006-03-01 00:00:00 | 2011-02-28 00:00:00 | Capital |  |  |  |  |  | opt-in
PMS50661 | Active |  |  | 2007-03-01 00:00:00 | 2014-02-28 00:00:00 | Capital |  |  |  |  |  | opt-in
PCE60092 | Active |  |  | 2006-08-01 00:00:00 | 2011-05-31 00:00:00 | Capital |  |  |  |  |  | opt-in
PSCE003 | Active |  |  | 2006-08-01 00:00:00 | 2014-07-31 00:00:00 | Capital |  |  |  |  |  | opt-in
PLB50011 | Expired | ProvSource Siemens Medical Diagnostics | Siemens | 2007-02-01 00:00:00 | 2010-07-31 00:00:00 | Non-Capital | Lab | [NAME] |  |  | Hold - Check with [NAME] on strategy |  | 10/29 Need data for analysis.  No information from GSA data set.  8/21: No reply from Rep for  current  [NAME] level for analysis.
PDR80010 | Active |  |  | 2008-01-01 00:00:00 | 2012-06-30 00:00:00 | Distribution
Future | Check w/Rhonda |  |  |  |  | Future
PXR90010 | Active |  |  | 2005-01-21 00:00:00 | 2012-12-31 00:00:00 | Capital
PMS60461 | Active |  |  | 2008-09-15 00:00:00 | 2013-12-31 00:00:00 | Capital
PMS60450 | Active |  |  | 2008-09-15 00:00:00 | 2013-12-31 00:00:00 | Capital
PCE80162 | Active |  |  | 2008-07-01 00:00:00 | 2011-06-30 00:00:00 | Capital
PSLB002 | Active |  |  | 2008-11-01 00:00:00 | 2011-10-31 00:00:00 | Non-Capital
PCE60031 | Active |  |  | 2008-02-01 00:00:00 | 2013-12-31 00:00:00 | Pharmacy
PSCE005 | Active |  |  | 2009-02-01 00:00:00 | 2012-01-31 00:00:00 | Capital
PSFM001 | Active |  |  | 2009-06-01 00:00:00 | 2012-05-31 00:00:00
PSVC960 | Active |  |  | 2009-04-01 00:00:00 | 2014-03-31 00:00:00
MS60122 | Expired | Novation Synthes Trauma | Synthes | 2009-11-01 00:00:00 | 2010-04-30 00:00:00 | Non-Capital | [NAME] | [NAME] | Tier 11 pricinig | opt-in | opt-in | opt-out | opt-in
[NAME] | Expired | ProvSource Smiths Medical Novaplus ABG Kits | Smiths Medical ASD Inc | 2003-04-01 00:00:00 | 2007-10-31 00:00:00 | Expired | Respiratory | [NAME] | No longer ProvSource.  MS70110 Novation Best Tier
PMS30053 | Expired | ProvSource Smiths DMR | Smiths Medical ASD Inc | 2004-10-13 00:00:00 | 2007-10-31 00:00:00 | Expired | Respiratory | [NAME] | No longer ProvSource. MS70122 [NAME]
PSCE004 | Expired | ProvSource Pedigo OR Minor Equipment | Pedigo Products Inc | 2006-02-01 00:00:00 | 2007-09-30 00:00:00 | Expired | Capital | [NAME] | Contract expired. | Reviewing Send launch package & product list without pricing to determine opportunity before analysis. | OPT-OUT/DEFER: May  evaluate after comparison of product line. | Pending transition & process. Send Launch package & product list without pricing to determine opportunity before analysis. | Citrus interested in analysis.  Contract is going to expire and not available for analysis. Pending
PSCE002 | Expired | ProvSource NuAire Barrier Isolator Products | NuAire, Inc. | 2005-10-01 00:00:00 | 2008-09-30 00:00:00 | Expired |  | [NAME] | Expired, Not extended |  |  |  | Near expiration.
PSCE001 | Expired | ProvSource Elekta Treatment Delivery and Planning Systems | Elekta | 2005-09-01 00:00:00 | 2008-08-31 00:00:00 | Expired |  | [NAME] | Expired.  [NAME] is working on extention. | OPT-OUT:  Do not use Elekta. | OPT-OUT/DEFER: Capital.  May consider when purchasing. | OPT-OUT: Swedish already has agreement negotiated prior to VHA & ProvSource.  Send the ProvSource product list 2-29-08 to review. | 8/21: Needs more info; pull list.
PMS10730 | Expired | ProvSource KCI Therapeutic Beds & Surfaces | KCI | 2006-01-01 00:00:00 | 2008-12-31 00:00:00 | Capital |  | [NAME] | [NAME] negotiated new pricing better than Novation best tier. Open for alliance member to join. [NAME] is separating the contract into two - Bariatric & Therapeutic.  See new contracts below. | REFER TO 2 NEW KCI CONTRACTS UNDER NEW COTNRACT FOR PARTICIPATION. | REFER TO 2 NEW KCI CONTRACTS UNDER NEW COTNRACT FOR PARTICIPATION. | REFER TO 2 NEW KCI CONTRACTS UNDER NEW COTNRACT FOR PARTICIPATION. | REFER TO 2 NEW KCI CONTRACTS UNDER NEW CONTRACT FOR PARTICIPATION.
PMS50293 | Expired | ProvSource Medline Surgical Non-Woven Products | Medline Industries, Inc./Mfg. | 2006-08-01 00:00:00 | 2009-07-31 00:00:00 | Non-Capital | [NAME] | [NAME] | Periop Resource Council Initiative 2008. Moving to KC | Periop Resource Council Initiative 2008. | Periop Resource Council Initiative 2008. | Swedish wanted to join. Strategy change for ProvSource including Non-Wovens to CPT bid prevented them from engaging in this contract.  Swedish OPT-OUT for CPT. | 12/10: Move fwd w/analysis of drapes&gowns 2009. Periop Resource Council Initiative 2008.
PSDL001 | Expired | ProvSource Fisher Healthcare Laboratory Distribution | Fisher Healthcare | 2005-10-15 00:00:00 | 2008-12-31 00:00:00 | Distribution | Lab | [NAME] | Lab resource council 2008 initiative. Plan to go out for bid.  NOT AVAILABLE FOR CURRENT ANALYSIS | Currently Using Cardinal Lab Resource Council initiative in 2008 | Multi-Care with Cardinal.  [NAME] with Fisher & signed Cardinal as secondary. Probable integration.  Lab Resource Council Initiative in 2008 | OPT-OUT: Not in scope due to laboratory outsourcing. | N/A.  Lab Resource Council initiative in 2008
PHS Agreement | Expired | Boston Sceientific Promus DES | Boston Scientific |  |  | PHS | [NAME] | [NAME] | PHS Initiative with Alliance participation. | OPT-IN: $84K savings | OPT-IN: $293K savings | OPT-OUT | OPT-OUT
PCE40256 | Expired | ProvSource Nellcor Puritan Bennett Ventilators | Nellcor Puritan Bennett | 2004-09-28 00:00:00 | 2009-02-28 00:00:00 | Capital | Respiratory | [NAME] | Extended for another year. | OPT-OUT:Purchased alternate brand prior to ProvSource. Purchased [NAME]. | N/A | OPT-OUT: Signed a new agreement with Marquette - Spring 2007 | OPT OUT
PMS50094 | Expired | ProvSource Tyco Healthcare Kendall Pneumatic Compression Devices | Tyco Healthcare | 2005-04-01 00:00:00 | 2009-12-31 00:00:00 | Non-Capital | [NAME] | [NAME] | Extended through Dec 2009.  Currently in negotiation | 3-26-09 Their facility is on addendum list.  Are they participating?    3-2-09 No savings opportunity. | 2-5-09: opt-in 1-13-09: OPT-IN received. | OPT-OUT:  New Wellspring Aircast Agreement just before VHA/ProvSource engagement.  Cannot change again. | 2/5/09: opt-in [NAME] finalized. [NAME] to send docs 12/10 Rudy/Cheryl finalizing. Kendall agreed. 11/25 [NAME] alerted, contacted supplier.   OPT-IN rec'd 8/14
PSMS003 | Expired | ProvSource Kendall Anti-Embolism Stocking Products | Kendall Company | 2005-10-01 00:00:00 | 2009-12-31 00:00:00 | Non-Capital | [NAME] | [NAME] | Extended through Dec 2009.  Currently in negotiation | 3-2-09 Analysis opt-ind.  Savings opportunity.  Presented analysis? | 1-13-09: OPT-IN received. | 4-13-09: using BSN.  2-5-09  analysis opt-ind. Savings opportunity.  Need to present to Swedish. | OPT-OUT 8/21;expiring soon.  No savings opportunity converting from Alba.  Conversion needed.
PMS30462 | Expired | ProvSource Regent Medical Surgical Gloves | Regent Hospital Products, LTD. | 2005-08-01 00:00:00 | 2009-12-31 00:00:00 | Non-Capital | [NAME] | [NAME] | [NAME] in 2009. Cheryl extending to co-terminate with Novation agreement 12/31/2009.  New Contract to be announced Dec 2009 | OPT-OUT: Just converted to Cardinal. | OPT-OUT: Analysis opt-ind. Presented Analysis. Not significant enough to convert. | OPT-OUT: Using Novation Medline contract for Surgical Gloves. | OPT-OUT: using [NAME].
PCE60102 | Active |  |  | 2009-06-01 00:00:00 | 2012-05-31 00:00:00
PCE50191 | Active |  |  | 2009-08-01 00:00:00 | 2012-09-30 00:00:00
[NAME] | Active |  |  | 2010-02-15 00:00:00 | 2012-12-31 00:00:00 | Future
Future | Active |  |  |  |  | Future
PDPCARD | Active |  |  | 2007-07-16 00:00:00 | 2011-04-30 00:00:00 | Distribution
PDP50016 | Active |  |  | 2007-02-09 00:00:00 | 2011-05-31 00:00:00 | Expired
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
PHS - Pharmacy | Active |  |  |  |  | PHS - Pharmacy
Future | In Progress |  |  |  |  | Potential Capital
Future | In Progress |  |  |  |  | Capital Equipment?
Future | In Progress |  |  |  |  | Capital Equipment?
Future | In Progress |  |  |  |  | Non-Capital
Future | In Progress |  |  |  |  | Non-Capital
Future | In Progress |  |  |  |  | Non-Capital
Future | In Progress |  |  |  |  | Non-Capital