Spreadsheet: 130509d1322400596-help-needed-with-information-retrieval-lookup-from-another-worksheet-multi-look
Sheet: Bids Lost

 | Bids Lost
 | Total Lost Business: |  | 20000
 | Total Lost Profit: |  | 2000 |  |  |  |  |  |  |  |  |  |  |  | Sum if Calcs
 | 2011 Q1 Business: |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2011 Q2 Business: |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2011 Q3 Business: |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2011 Q4 Business: |  | 20000 |  |  |  |  |  |  |  |  |  |  |  | 20000
 | 2012 Q1 Business: |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Q2 Business: |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Q3 Business: |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2012 Q4 Business: |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | Expected | Expected | Project | Project | % chance |  |  |  |  |  |  |  | Chart Values
 | Project Name |  |  | Scope / Progress / Notes |  |  |  | Revenue | Profit | Start | Duration | of confirming |  |  | [NAME] |  | Month Year Calc |  |  | Month/Year | Revenue | Profit
 | Project D |  |  | Build Shuttle System |  |  |  | 20000 | 2000 | 2011-11-01 00:00:00 | 0 | 0 |  |  | Quarter 4, 2011 |  | 11 2011 |  |  | 2011-01-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-03-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-05-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-06-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-07-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-08-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-09-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-11 00:00:00 | 20000 | 2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-11 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-01 00:00:00 | 0 | 0
 | 2011-11-27 00:00:00
 | Project Name | Scope | Total Project | Profit | Project Start | Duration
Confirmed
 | Christ Church of the Valley | electrical installed; waiting on DeSisti hoists | 27517.25 | 4127.59 | 2011-11-01 00:00:00
 | Firearms Range - NM | waiting on client | 51835.09 | 9000 | Nov-Dec 2011
 | Fountain Hills Theater Audio | scheduled for before Christmas;waiting on deposit | 29045 | 6492.28 | 2011-12-01 00:00:00
 | MIM | labor overruns; lack of project mgr | 6880 | 0 | 2011-10-01 00:00:00
 | Neely Elementary | need to install 2 carriers | 7977.05 | 1833.15 | 2011-11-01 00:00:00
 | Sacaton Middle School | need to prep installation | 12239.89 | 2968.55 | 2011-11-01 00:00:00
 | [NAME] CalState | addt’l work from original install | 1915.88 | 562.48 | 2011-11-01 00:00:00
 | [NAME] | install done | 5022.71 | 1038.96 | 2011-08-01 00:00:00
 | South Mountain Community College | install complete | 7025.01 | 1396.96 | 2011-10-01 00:00:00
 | Sun Lakes Community Center | waiting on deposit to order equipment | 12121.56 | 3270.06 | 2011-11-01 00:00:00
 | Superstition Sunrise RV Resort | need to adjust 2 lights & then invoice | 10268.26 | 2226.73 | 2011-10-01 00:00:00
 | Westin Repair Work | getting parts ordered | 5577.99 | 1392.78 | 2011-11-01 00:00:00
 | Zoolights | install done; programming ongoing | 20525.74 | 5084.73 | 10/18-11/2
 |  | TOTAL
Proposed
 | AZ Jewish Historical | acoustic drapes/panels | 11327.57 | 3221.45
 | Basis Chandler Charter School | revising for just drapes | 47743.29 | 9693.74
 | Basis Peoria Campus |  | 19042.27 | 7141.39
 | Blue Ridge High School | going for grant; rigging safety issue | 35066.04 | 7013.21 | Late 2012/2013
 | Burgeon Design Group | two more library exhibts | 18632.09 | 2793.47 | next year
 | Catalina Foothills HS | haven’t bid yet - lack of time
 | Central AZ College | bids due 10/25
 | Christ Church of the Valley | retrofit kit on Peoria campus | 7582.96 | 1374.8 | Early 2012
 | Dallas Stadium Lighting | waiting on [NAME] advertising dollars | 24772.55 | 5936.91 | 2012 if ever
 | [NAME] | drapes at various high schools | 24364.99 | 3251.7
 | Grand Canyon Arena Design Work | design only | 3200 | 1952 | Early 2012
 | Greenway High School | bid due this week
 | Hyatt Century Lighting | CA project | 19984.55
 | ISS | drapes/lights for [NAME]’s installs | 13703.78 | 2101.51
 | [NAME] strand retrofit kits | selling kits to [NAME] install | 16920 | 1471.2 | 2011-12-01 00:00:00
 | Kayenta High School TV Studio | selling hardware to school-no install | 2387.42 | 624.08 | 2011-11-01 00:00:00
 | Lightform LEDs | long shot in my opinion | 176129.4 | 34386
 | [NAME] | waiting to hear | 55350 | 9800.66 | Early 2012
 | [NAME] | drape change out-all labor | 2399.69 | 571.25
 | Mogollan High School | gym exterior audio system; rural area | 11774.16 | 1747.43
 | Mount Lutheran Church | AV upgrades | 44276.56 | 7892.4
 | NAU [NAME] | waiting on confirmation from Shaum Electric | 213365 | 25360.5 | 2011-12-01 00:00:00
 | NAU CEW Auditorium | project delayed to next fiscal year | 204452.58 | 26270.98 | 2012-2013
 | [NAME] | waiting for other bidders | 10708 | 1954.91
 | Orangewood Narazene Church | lighting retrofit | 15847 | 3563.97
 | Phoenix College Music Room | applying for funding | 28662.99 | 5529.03
 | Phoenix College [NAME] | revised previous quote for budghet | 17117.82 | 2154.57 | Early 2012
 | Phoenix 1st Assembly dimmers | possibly next year or | 86460 | 17618.48 | Late 2012
 | Phoenix 1st Assembly retrofit | retrofitting dimmers to save cost | 18200 | 3748.71
 | Phoenix 1st Assembly drape | haven’t bid yet - lack of time
 | Phoenix 1st Assembly projector | haven’t heard-most likely lost | 19424.63 | 1952.85
 | Phoenix Theatre Hall of Mirrors | probably installing soon | 2418.18 | 806.04 | 2011-11-01 00:00:00
 | Phoenix Theatre OFE | haven’t bid yet  $493K is budget |  |  | Fall 2012
 | Pima Community College | sale only | 30861.44 | 3934.12 | 2011-12-01 00:00:00
 | Redemption Church | need to add parts/pieces | 37798.04 | 5154.92
 | Red Mtn. High School | haven’t bid yet - lack of time
 | Rock Point Church Phase ! |  | 300007.73 | 53495.45 | Summer 2012
 | Rock Point Church Phase II | haven’t bid yet - lack of time |  |  | Fall 2012
 | Scottsdale Studios | haven’t bid yet - lack of time
 | South Mountain CC Audio System | bids 10/25/11 |  |  | Nov-Dec 2011
 |  | TOTAL
Bid Development
 |  | TOTAL
Bids Lost
 | Ak-Chin Casino | bought fixtures from electrical contractor | 46657.68 | 8242
 | Blessed Pope [NAME] | budget too high | 19499.34 | 4517.09
 | Burk Elementary | haven’t heard anything | 12396.95 | 2625.63
 | Del Norte Baptist Church | NM bid to CCS Presentation | 56422.37 | 10105.71
 | Millennium High School | cheaper bid | 21178.84 | 3708.43
 | Phoenix First Assembly LEDs | went with cheaper Chinese panels | 514894.07 | 50351.87
 | Yapavai College | stayed with 4 Wall - original supplier