Spreadsheet: 54534d1254514776-add-fields-in-a-pivot-sample
Sheet: _original(1).csv)BPM_Forecast_V

Region | Subregion | Opportunity Owner | Account Name | Account Owner | Opportunity Name | Product Category | Product Name | Solution Category | User Name | Opportunity Type | Sales Stage | Forecast | Qualtifiable Value | Quota | Monthly Difference | Monthly % | Monthly % | Monthly Difference | Quota | 1X - One-Time | 1X - One-Time Revenue | BIE Revenue | Close Date | CLOSE MONTH | Dodge Close Date | Priority - Top 25 | Parent Account | Quota Value - Growth Goal | Current Dodge Close Month
60^ | 662^ | tom_twomey | Kingspan/Tate Access Floors | tom_twomey | Dodge TLSPSH IRV 06-10-09 C#2377660 | MHC Analytics | TLSPSH | Get Smart | [NAME], [NAME] | Revision | Proposal | 80000 |  | 330000 | -250000 | 24.242424242424 | 266.666666666667 | 50000 | 30000 | N | 0 | 80000 | 2009-10-15 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^ | 662^ | tom_twomey | Tate Access Floors | tom_twomey | Dodge TLNP DRV C#2256978 07-16-09 | MHC Analytics | TLNP | Get Smart | [NAME], [NAME] | Revision | Proposal | -27600 |  | 222400 | -250000 | -12.410071942446 | 35.567010309278 | 50000 | -77600 | N | 0 | -27600 | 2009-10-15 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^ | 703^ | brian_simon | Grace Construction Products | brian_simon | Dodge MAG TF 08-11-09 C#2380822 | MHC Analytics | CAS | Get Smart | [NAME], [NAME] | Renewal | Closed/Won | 113.15 |  | 250113.15 | -250000 | 0.045239524591 | -0.226813278449 | 50000 | -49886.85 | N | 0 | 113.15 | 2009-10-15 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | [NAME] Inc |  | Current Month
60^ | 703^ | brian_simon | Grace Construction Products | brian_simon | Dodge MAG TF 08-11-09 C#2380822 | MHC Analytics | CMFS | Get Smart | [NAME], [NAME] | Renewal | Closed/Won | 438.05 |  | 250438.05 | -250000 | 0.174913516536 | -0.883843351603 | 50000 | -49561.95 | N | 0 | 438.05 | 2009-10-15 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | [NAME] Inc |  | Current Month
60^ | 703^ | brian_simon | Grace Construction Products | brian_simon | Dodge TLSPAC TF 08-11-09 C#2380821 | MHC Analytics | TLSPAC | Get Smart | [NAME], [NAME] | Renewal | Closed/Won | 1490.75 |  | 251490.75 | -250000 | 0.592765340276 | -3.073125228694 | 50000 | -48509.25 | N | 0 | 1490.75 | 2009-10-15 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | [NAME] Inc |  | Current Month
60^ | 602^ | reginald_lorjuste | Baldwin Hardware Corp | reginald_lorjuste | MACFD | MHC Analytics | MACFD | Get Smart | Lorjuste, Reginald | Revision | Quote | 3144 |  | 253144 | -250000 | 1.241980848845 | -6.70991975414 | 50000 | -46856 | N | 0 | 3144 | 2009-10-30 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^ | 602^ | reginald_lorjuste | LEHIGH ELECTRIC PRODUCTS | reginald_lorjuste | DODGE-LEHIGH-ELEC-TF-C#2383050-11/1/09 | MHC Analytics | TLSPSH | Get Smart | Lorjuste, Reginald | Renewal | Quote | 897 |  | 250897 | -250000 | 0.357517228185 | -1.826772294972 | 50000 | -49103 | N | 0 | 897 | 2009-10-30 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^ |  | chris_ramsey | Dietrich Industries, Inc. | john_vigne | Dietrich - DCPB | MHC Analytics | DCP-B | Get Smart | [NAME], [NAME] | Revision | Quote | 7800 |  | 257800 | -250000 | 3.025601241272 | -18.483412322275 | 50000 | -42200 | N | 0 | 7800 | 2009-10-30 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^ |  | chris_ramsey | Overly Manufacturing Co | john_vigne | Overly - TL specsearch | MHC Analytics | TLSPSH | Get Smart | [NAME], [NAME] | Revision | Quote | 30000 |  | 280000 | -250000 | 10.714285714286 | -150 | 50000 | -20000 | N | 0 | 30000 | 2009-10-30 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^69^ | 608^ | alan_woller | Shenandoah Decorative Iron Works | pat_keck | GIR ([NAME]) | [NAME] | Network Platinum | Find Opportunity | Woller, [NAME] | New | Quote | 4153 |  | 254153 | -250000 | 1.63405507706 | -9.058389861932 | 50000 | -45847 | N | 0 | 4153 | 2009-10-09 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^69^ | 608^ | alan_woller | Freedom Doors | alan_woller | GIR ([NAME]) | [NAME] | Network Platinum | Find Opportunity | Woller, [NAME] | New | Quote | 5331.5 |  | 255331.5 | -250000 | 2.088069822956 | -11.935704131547 | 50000 | -44668.5 | N | 0 | 5331.5 | 2009-10-16 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^69^ | 608^ | alan_woller | POR-15 | pat_keck | Network | [NAME] | Network Platinum | Find Opportunity | Woller, [NAME] | New | Quote | 6897.5 |  | 256897.5 | -250000 | 2.684922975117 | -16.002552056145 | 50000 | -43102.5 | N | 0 | 6897.5 | 2009-10-16 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^69^ | 608^ | alan_woller | West Chester Modular Co | rochelle_staiano | NTR ([NAME]) | [NAME] | Network Platinum | Find Opportunity | Woller, [NAME] | New | Quote | 7500 |  | 257500 | -250000 | 2.912621359223 | -17.647058823529 | 50000 | -42500 | N | 0 | 7500 | 2009-10-16 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^69^ | 608^ | alan_woller | Arundel Signs | pat_keck | GIR ([NAME]) | [NAME] | Network Platinum | Find Opportunity | Woller, [NAME] | New | Quote | 5500 |  | 255500 | -250000 | 2.152641878669 | -12.359550561798 | 50000 | -44500 | N | 0 | 5500 | 2009-10-23 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
60^69^ | 608^ | alan_woller | Topsource Corporation | alan_woller | Dodge ([NAME]) | [NAME] | Network Platinum | Find Opportunity | Woller, [NAME] | New | Quote | 2051.5 |  | 252051.5 | -250000 | 0.813920964565 | -4.278548859714 | 50000 | -47948.5 | N | 0 | 2051.5 | 2009-10-30 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
62^ | 721^ | keven_mccook | PROMETHEUM CEU | keven_mccook | TLNP | MHC Analytics | TLNP | Get Smart | Mccook, Keven | New | Proposal | 52000 |  | 302000 | -250000 | 17.218543046358 | 2600 | 50000 | 2000 | N | 0 | 52000 | 2009-10-02 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
62^ | 745^ | charlie_foti | PGT IND | charlie_foti | CF PGT IND 2290178 MACFD CAN | MHC Analytics | MACFD | Get Smart | [NAME], [NAME] | Mortal | Closed/Won | -17455.42 |  | 232544.58 | -250000 | -7.506268260477 | 25.876971783735 | 50000 | -67455.42 | N | 0 | -17455.42 | 2009-10-09 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
62^ | 720^ | [NAME] | Wilsonart International Inc | [NAME] | Players Database-new | MHC Analytics | PLAYER | Get Smart | Coltrin, [NAME] | Add A Brand | Quote | 15000 |  | 265000 | -250000 | 5.660377358491 | -42.857142857143 | 50000 | -35000 | N | 0 | 15000 | 2009-10-15 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
62^ | 721^ | keven_mccook | INVISTA | keven_mccook | ANALYTICS | MHC Analytics | MACFD | Get Smart | Mccook, Keven | Add A Brand | Proposal | 51862 |  | 301862 | -250000 | 17.180698464861 | 2785.28464017186 | 50000 | 1862 | N | 0 | 51862 | 2009-10-15 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
62^ | 497^ | scott_stooksberry | Echo Bridge South | scott_stooksberry | SS-Echo Bridge South-Dodge Increase-Natalie | MHC Analytics | TLSPSH | Get Smart | [NAME], [NAME] | Revision | Quote | 2472.17 |  | 252472.17 | -250000 | 0.979185151377 | -5.201520877347 | 50000 | -47527.83 | N | 0 | 2472.17 | 2009-10-25 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
62^ | 841^ | karl_krutzky | ArtUSA Noise Control Products, Inc. | karl_krutzky | KK-ArtUSA Noise Control Products, Inc.-Tim White | MHC Analytics | TLSPAL | Get Smart | [NAME], [NAME] | New | Quote | 5001 |  | 255001 | -250000 | 1.96116877973 | -11.113580301784 | 50000 | -44999 | N | 0 | 5001 | 2009-10-29 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
62^ | 497^ | scott_stooksberry | Sanderson Plumbing Products | scott_stooksberry | SS-Sanderson-TLSPSH-Whitney | MHC Analytics | TLSPSH | Get Smart | [NAME], [NAME] | New | Quote | 20000 |  | 270000 | -250000 | 7.407407407407 | -66.666666666667 | 50000 | -30000 | N | 0 | 20000 | 2009-10-30 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
62^ | 720^ | [NAME] | Crossville Ceramics | scott_stooksberry | #2361952 DR Cancellation | MHC Dodge | Dodge Reports General | Find Opportunity | Coltrin, [NAME] | Revision | Closed/Won | -8571.66 |  | 241428.34 | -250000 | -3.550395119314 | 14.634483639357 | 50000 | -58571.66 | N | 0 | -8571.66 | 2009-10-09 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
62^ | 616^ | daniel_ritz | Saniglaze | daniel_ritz | Dodge Cancel REf#2385886 | [NAME] | Network Platinum | Find Opportunity | Ritz, [NAME] | Mortal | Closed/Won | -24528 |  | 225472 | -250000 | -10.87851263128 | 32.911120652641 | 50000 | -74528 | N | 0 | -24528 | 2009-10-02 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month
62^ | 625^ | ethan_manley | Awntek | ethan_manley | EM - Awntek - Dodge Goldwire | [NAME] | Network Platinum | Find Opportunity | Manley, [NAME] | Revision | Closed/Won | -9400 |  | 240600 | -250000 | -3.906899418121 | 15.824915824916 | 50000 | -59400 | N | 0 | -9400 | 2009-10-02 00:00:00 | OCTOBER | 2009-10-09 00:00:00 | Unspecified | Unspecified |  | Current Month