Spreadsheet: 130510d1322404498-help-needed-with-information-retrieval-lookup-from-another-worksheet-forecast-test
Sheet: Proposed

 | Proposed
 | Total Proposed Business:
 | Total Proposed Profit: |  |  |  |  |  |  |  |  |  |  |  | Sum if Calcs
 | 2011 Q1 Business:
 | 2011 Q2 Business:
 | 2011 Q3 Business:
 | 2011 Q4 Business:
 | 2012 Q1 Business:
 | 2012 Q2 Business:
 | 2012 Q3 Business:
 | 2012 Q4 Business:
 | all values on this worksheet are
 | figured as a percentage of values
 | based on confirm chance percentage
 | Project Name | Scope / Progress / Notes | Expected Revenue | Expected Profit | Project Start | Project Duration | % chance of confirming |  |  |  |  |  |  |  |  |  |  | Chart Values
 |  |  |  |  |  |  |  |  |  | % revenue | % profit |  | [NAME] |  | Month Year Calc |  |  | Month/Year | Revenue | Profit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-01 00:00:00
 | Project Name | Profit
Confirmed
 | Christ Church of the Valley | 4127.59
 | Firearms Range - NM | 9000
 | Fountain Hills Theater Audio | 6492.28
 | MIM | 0
 | Neely Elementary | 1833.15
 | Sacaton Middle School | 2968.55
 | [NAME] CalState | 562.48
 | [NAME] | 1038.96
 | South Mountain Community College | 1396.96
 | Sun Lakes Community Center | 3270.06
 | Superstition Sunrise RV Resort | 2226.73
 | Westin Repair Work | 1392.78
 | Zoolights | 5084.73
Proposed | AZ Jewish Historical | 3221.45
 | Basis Chandler Charter School | 9693.74
 | Basis Peoria Campus | 7141.39
 | Blue Ridge High School | 7013.21
 | Burgeon Design Group | 2793.47
 | Catalina Foothills HS
 | Central AZ College
 | Christ Church of the Valley | 1374.8
 | Dallas Stadium Lighting | 5936.91
 | [NAME] | 3251.7
 | Grand Canyon Arena Design Work | 1952
 | Greenway High School
 | Hyatt Century Lighting
 | ISS | 2101.51
 | [NAME] strand retrofit kits | 1471.2
 | Kayenta High School TV Studio | 624.08
 | Lightform LEDs | 34386
 | [NAME] | 9800.66
 | [NAME] | 571.25
 | Mogollan High School | 1747.43
 | Mount Lutheran Church | 7892.4
 | NAU [NAME] | 25360.5
 | NAU CEW Auditorium | 26270.98
 | [NAME] | 1954.91
 | Orangewood Narazene Church | 3563.97
 | Phoenix College Music Room | 5529.03
 | Phoenix College [NAME] | 2154.57
 | Phoenix 1st Assembly dimmers | 17618.48
 | Phoenix 1st Assembly retrofit | 3748.71
 | Phoenix 1st Assembly drape
 | Phoenix 1st Assembly projector | 1952.85
 | Phoenix Theatre Hall of Mirrors | 806.04
 | Phoenix Theatre OFE
 | Pima Community College | 3934.12
 | Redemption Church | 5154.92
 | Red Mtn. High School
 | Rock Point Church Phase ! | 53495.45
 | Rock Point Church Phase II
 | Scottsdale Studios
 | South Mountain CC Audio System
Bid Development
Bids Lost
 | Ak-Chin Casino | 8242
 | Blessed Pope [NAME] | 4517.09
 | Burk Elementary | 2625.63
 | Del Norte Baptist Church | 10105.71
 | Millennium High School | 3708.43
 | Phoenix First Assembly LEDs | 50351.87
 | Yapavai College