{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Questions","Question Details"],"not_rendered":{"defined_names":31,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Questions","index":0,"n_rows":104,"n_cols":10,"rows_kept":104,"merged":[[0,0,0,5],[0,6,0,7],[2,3,2,7],[4,3,4,5],[6,1,6,7],[7,1,7,7],[8,1,8,7],[9,1,9,7],[10,1,10,4],[11,2,11,5],[11,6,12,6],[11,7,12,7],[11,8,12,8],[11,9,12,9],[14,2,14,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[17,2,17,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[17,9,18,9],[20,2,20,5],[20,6,21,6],[20,7,21,7],[20,8,21,8],[20,9,21,9],[23,1,23,4],[24,2,24,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[24,9,25,9],[27,2,27,5],[27,6,28,6],[27,7,28,7],[27,8,28,8],[27,9,28,9],[30,2,30,5],[30,6,31,6],[30,7,31,7],[30,8,31,8],[30,9,31,9],[33,2,33,5],[33,6,34,6],[33,7,34,7],[33,8,34,8],[33,9,34,9],[36,2,36,5],[36,6,37,6],[36,7,37,7],[36,8,37,8],[36,9,37,9],[39,1,39,4],[40,2,40,5],[40,6,41,6],[40,7,41,7],[40,8,41,8],[40,9,41,9],[43,2,43,5],[43,6,44,6],[43,7,44,7],[43,8,44,8],[43,9,44,9],[46,2,46,5],[46,6,47,6],[46,7,47,7],[46,8,47,8],[46,9,47,9],[49,2,49,5],[49,6,50,6],[49,7,50,7],[49,8,50,8],[49,9,50,9],[52,2,52,5],[52,6,53,6],[52,7,53,7],[52,8,53,8],[52,9,53,9],[55,2,55,5],[55,6,56,6],[55,7,56,7],[55,8,56,8],[55,9,56,9],[58,2,58,5],[58,6,59,6],[58,7,59,7],[58,8,59,8],[58,9,59,9],[61,2,61,5],[61,6,62,6],[61,7,62,7],[61,8,62,8],[61,9,62,9],[64,1,64,4],[65,2,65,5],[65,6,66,6],[65,7,66,7],[65,8,66,8],[65,9,66,9],[68,2,68,5],[68,6,69,6],[68,7,69,7],[68,8,69,8],[68,9,69,9],[71,2,71,5],[71,6,72,6],[71,7,72,7],[71,8,72,8],[71,9,72,9],[74,1,74,4],[75,2,75,5],[75,6,76,6],[75,7,76,7],[75,8,76,8],[75,9,76,9],[78,2,78,5],[78,6,79,6],[78,7,79,7],[78,8,79,8],[78,9,79,9],[81,2,81,5],[81,6,82,6],[81,7,82,7],[81,8,82,8],[81,9,82,9],[84,2,84,5],[84,6,85,6],[84,7,85,7],[84,8,85,8],[84,9,85,9],[87,2,87,5],[87,6,88,6],[87,7,88,7],[87,8,88,8],[87,9,88,9],[90,1,90,7],[92,2,92,7],[93,2,93,7],[94,2,94,7],[95,2,95,7],[96,2,96,7],[97,2,97,7],[98,2,98,7],[99,2,99,7],[100,2,100,7],[101,2,101,7],[102,2,102,7],[103,2,103,7]]}
["Project Selection Program  v1.1 © Thomas C Schleifer, Ph.D. tschleifer@q.com",{"$nulls":5},{"$f":"IF(Score<0.1,0.1,IF(Score>0.9,0.9,Score))","v":{"v":0.5,"d":"50.0%"}}]
[]
[null,null,"Project Name:"]
[]
[null,null,"Completed By:",{"$nulls":3},"Date:"]
[]
[null,"Introduction:  Click here",{"$nulls":6},"Possible Points",{"$f":"SUM(G12:G88)","v":{"v":100,"d":"100 pts"}}]
[null,"                                    Directions:  Click here",{"$nulls":6},"Total Points",{"$f":"SUM(J12:J88)","v":{"v":50,"d":"50 pts"}}]
[null,"                                                                                                    Change weights:  Click here",{"$nulls":6},"Score",{"$f":"TotalPoints/PossiblePoints","v":{"v":0.5,"d":"50%"}}]
[null,"            Click on question for more detail"]
[null,"Section 1 - Project Fit",{"$nulls":4},"Weight","Default Weight","Choice","Score"]
[null,"1.1","Has the firm successfully completed projects this size (this large)?",{"$nulls":3},{"v":10,"d":"10 pts"},{"v":10,"d":"10 pts"},0,{"$f":"CHOOSE(I12+1,0.5,0,0.5,1)*G12","v":5}]
[]
[]
[null,"1.2","Has the firm successfully completed projects of this type?",{"$nulls":3},{"v":10,"d":"10 pts"},{"v":10,"d":"10 pts"},0,{"$f":"CHOOSE(I15+1,0.5,0,0.5,1)*G15","v":5}]
[]
[]
[null,"1.3","Has the firm successfully completed projects in this geographic area?",{"$nulls":3},{"v":10,"d":"10 pts"},{"v":10,"d":"10 pts"},0,{"$f":"CHOOSE(I18+1,0.5,0,0.5,1)*G18","v":5}]
[]
[]
[null,"1.4","Has firm successfully completed projects with this Owner/GC/CM?",{"$nulls":3},{"v":10,"d":"10 pts"},{"v":10,"d":"10 pts"},0,{"$f":"CHOOSE(I21+1,0.5,0,0.5,1)*G21","v":5}]
[]
[]
[null,"Section 2 - Firm's Experience",{"$nulls":4},"Weight","Default Weight"]
[null,"2.1","Has the firm successfully completed projects with this Owner/GC/CM's representatives, inspectors, etc.?",{"$nulls":3},{"v":2,"d":"2 pts"},{"v":2,"d":"2 pts"},0,{"$f":"CHOOSE(I25+1,0.5,0,0.5,1)*G25","v":1}]
[]
[]
[null,"2.2","Has the firm successfully completed projects with this designer/architect/engineer?",{"$nulls":3},{"v":5,"d":"5 pts"},{"v":5,"d":"5 pts"},0,{"$f":"CHOOSE(I28+1,0.5,0,0.5,1)*G28","v":2.5}]
[{"$nulls":3}," "]
[]
[null,"2.3","Has the firm successfully completed projects with this designer/architect/engineer’s field personnel, inspectors, etc.?",{"$nulls":3},{"v":2,"d":"2 pts"},{"v":2,"d":"2 pts"},0,{"$f":"CHOOSE(I31+1,0.5,0,0.5,1)*G31","v":1}]
[]
[]
[null,"2.4","Has the firm’s estimating team priced this type of project?",{"$nulls":3},{"v":4,"d":"4 pts"},{"v":4,"d":"4 pts"},0,{"$f":"CHOOSE(I34+1,0.5,0,0.5,1)*G34","v":2}]
[]
[]
[null,"2.5","Has the firm’s anticipated field team (PM, Supt, Foreman) built this type/size of project?",{"$nulls":3},{"v":6,"d":"6 pts"},{"v":6,"d":"6 pts"},0,{"$f":"CHOOSE(I37+1,0.5,0,0.5,1)*G37","v":3}]
[]
[]
[null,"Section 3 - Project Complexity",{"$nulls":4},"Weight","Default Weight"]
[null,"3.1","Is the required project schedule reasonable?",{"$nulls":3},{"v":4,"d":"4 pts"},{"v":4,"d":"4 pts"},0,{"$f":"CHOOSE(I41+1,0.5,0,0.5,1)*G41","v":2}]
[]
[]
[null,"3.2","Is there sufficient labor available to produce the project? (consider available skill levels)",{"$nulls":3},{"v":5,"d":"5 pts"},{"v":5,"d":"5 pts"},0,{"$f":"CHOOSE(I44+1,0.5,0,0.5,1)*G44","v":2.5}]
[]
[]
[null,"3.3","Has the firm had prior successful experience with the intended major subcontractors/vendors/etc.?",{"$nulls":3},{"v":5,"d":"5 pts"},{"v":5,"d":"5 pts"},0,{"$f":"CHOOSE(I47+1,0.5,0,0.5,1)*G47","v":2.5}]
[]
[]
[null,"3.4","Are there unusual access, room-to-work, parking, dust, noise, storage space, traffic, etc. issues?",{"$nulls":3},{"v":3,"d":"3 pts"},{"v":3,"d":"3 pts"},0,{"$f":"CHOOSE(I50+1,0.5,0,0.5,1)*G50","v":1.5}]
[]
[]
[null,"3.5","Are there unusual ground or surface water conditions?",{"$nulls":3},{"v":3,"d":"3 pts"},{"v":3,"d":"3 pts"},0,{"$f":"CHOOSE(I53+1,0.5,0,0.5,1)*G53","v":1.5}]
[]
[]
[null,"3.6","Are there rock, soft soils, unusually deep excavations,etc. that may complicate or delay the project?",{"$nulls":3},{"v":3,"d":"3 pts"},{"v":3,"d":"3 pts"},0,{"$f":"CHOOSE(I56+1,0.5,0,0.5,1)*G56","v":1.5}]
[]
[]
[null,"3.7","Are there unusual, circular, curved or angled design elements: i.e. walls, bridges, roofs, structures or other that may complicate/delay the project?",{"$nulls":3},{"v":4,"d":"4 pts"},{"v":4,"d":"4 pts"},0,{"$f":"CHOOSE(I59+1,0.5,0,0.5,1)*G59","v":2}]
[]
[]
[null,"3.8","Are there critical long-lead, sole source or unusual items that may delay the project?",{"$nulls":3},{"v":2,"d":"2 pts"},{"v":2,"d":"2 pts"},0,{"$f":"CHOOSE(I62+1,0.5,0,0.5,1)*G62","v":1}]
[]
[]
[null,"Section 4 - Financial and cash flow impacts",{"$nulls":4},"Weight","Default Weight"]
[null,"4.1","Is the project owner’s financing in place? ",{"$nulls":3},{"v":2,"d":"2 pts"},{"v":2,"d":"2 pts"},0,{"$f":"CHOOSE(I66+1,0.5,0,0.5,1)*G66","v":1}]
[]
[]
[null,"4.2","Does the firm have experience with the payment processes of this owner/GC/CM?",{"$nulls":3},{"v":2,"d":"2 pts"},{"v":2,"d":"2 pts"},0,{"$f":"CHOOSE(I69+1,0.5,0,0.5,1)*G69","v":1}]
[]
[]
[null,"4.3","Will this project strain the organization’s resources: i.e., financial, equipment, manpower, management, or other?",{"$nulls":3},{"v":3,"d":"3 pts"},{"v":3,"d":"3 pts"},0,{"$f":"CHOOSE(I72+1,0.5,0,0.5,1)*G72","v":1.5}]
[]
[]
[null,"Section 5 - Contract issues",{"$nulls":4},"Weight","Default Weight"]
[null,"5.1","Are contract terms reasonable?",{"$nulls":3},{"v":1,"d":"1 pts"},{"v":1,"d":"1 pts"},0,{"$f":"CHOOSE(I76+1,0.5,0,0.5,1)*G76","v":0.5}]
[]
[]
[null,"5.2","Are there any unusual payment provisions, retainage issues or liquidated damages that will affect cash flow?",{"$nulls":3},{"v":1,"d":"1 pts"},{"v":1,"d":"1 pts"},0,{"$f":"CHOOSE(I79+1,0.5,0,0.5,1)*G79","v":0.5}]
[]
[]
[null,"5.3","Are there any unusual bonding requirements?",{"$nulls":3},{"v":1,"d":"1 pts"},{"v":1,"d":"1 pts"},0,{"$f":"CHOOSE(I82+1,0.5,0,0.5,1)*G82","v":0.5}]
[]
[]
[null,5.4,"Are there any unusual insurance requirements?",{"$nulls":3},{"v":1,"d":"1 pts"},{"v":1,"d":"1 pts"},0,{"$f":"CHOOSE(I85+1,0.5,0,0.5,1)*G85","v":0.5}]
[]
[]
[null,5.5,"Are there any unusual indemnity issues? ",{"$nulls":3},{"v":1,"d":"1 pts"},{"v":1,"d":"1 pts"},0,{"$f":"CHOOSE(I88+1,0.5,0,0.5,1)*G88","v":0.5}]
[]
[]
[null,"Section 6 - Additional Issues to Consider (these are not scored)"]
[]
[null,6.1,"Do you believe you have a competitive edge on this project?"]
[null,null,"Going after a project generally has a cost associated with it along with potential lost opportunity if the use of resources to get the project prevents or impacts going after another job or reduces efforts of attracting other projects. This makes the measurement of a competitive edge or lack of one significant. Where there is a competitive edge on a project it may make sense to invest more resources than on one where there is less or no competitive edge. This is difficult to measure, but for most contractors it is in intuitive."]
[null,6.2,"Do you believe another contractor(s) has a competitive edge on this project?"]
[null,null,"Realistically recognizing any competitive edge other contractors may have is valuable knowledge and can assist in a project selection decision. Most are familiar with projects where a favored contactor was the owner/GC/CM’s obvious choice and many other contractors wasted a lot of effort and resources only to see the obvious choice selected. Screening out projects that a firm has limited chance of capturing saves considerable resources which can be applied to projects with a higher likelihood of success and can potentially increase sales. "]
[null,6.3,"Is there consensus within your organization about perusing this project?"]
[null,null,"When everyone in an organization is excited about pursuing a particular project the odds of capturing that work go up through the quantity and quality of the energy expended. The converse is true when there is little enthusiasm for a project making capturing it more difficult. There are situations when not going after a project is the best project selection decision. If some or many are concerned about a certain project it may be the wrong job for the company"]
[null,6.4,"Is your “gut feeling” about this project negative or positive"]
[null,null,"The expression; “If all else fails trust your gut” can be a valuable inclusion in the project selection process. The information collected from the above questions is of great value, however, if persons in responsible positions within an organization still have a gut feeling about a positive or negative decision it probably makes sense to reevaluate the data before making a final decision."]
[null,6.5,"How does the project fit with the existing/anticipated backlog? "]
[null,null,"A contractor whose current work is running smoothly has only limited exposure in taking on additional work. However, a contractor managing a troubled job or two may encounter additional risk in adding the next project. A well-managed and organized backlog has reasonably low exposure and makes additional, prospective projects attractive. A troubled backlog has higher risk which may indicate that this may not be the time to add another project."]
[null,6.6,"Does the contract include Consequential Damages or are they expressed or implied? "]
[null,null,"Consequential Damages are damages resulting as a consequence of the project. The owner is the usual party damaged, the public and others may also be included. Fairly common are damages that result when a revenue-generating project is delivered late such as a restaurant, hotel or retail business. The damages include loss of revenue because the intended use is delayed which can result in serious potential liability for a contractor that causes this to happen. Some contractors will not undertake such exposure which unlike liquidated damages cannot be measured in advance."]

{"sheet":"Question Details","index":1,"n_rows":26,"n_cols":3,"rows_kept":26}
["Item","Question","Description"]
["1.1","Has the firm successfully completed projects of this size?","Attempting projects larger than a firm has experience with, generally measured in dollars, is a discriminator of project success. A project 10% larger than anything the organization has profitable experience with is reasonably low risk. A project twice as large is high risk. The user should use judgement in pursuing projects larger than they have successful experience with.\n"]
["1.2","Has the firm successfully completed projects of this type?","Similar type of project means work that is comparable in nature to work the organization has specific experience completing at a profit either with their own forces, subcontracted or a combination of both. Type of project includes contracting method such as CMAR, Design-Build, Design-Bid-Build, etc.\n"]
["1.3","Has the firm successfully completed projects in this geographic area?","Geographic area is a significant discriminator of potential project success because of the impact of local knowledge and differences in local practices. This question addresses the organization's experience in the area of the project. Has the firm worked successfully and profitably here under current management?\n"]
["1.4","Has the firm successfully completed projects with this owner?","The owner is the entity that will own and/or pay for the project and may or may not be the direct user of the project. For example, a state may procure a road project (owner), but not be the user which is the public. The question address the entity that the user will contract with and answer to and if that is two separate parties or agencies both should be considered.\n"]
["2.1","Has the firm successfully completed projects with this owner’s representatives inspectors, etc.?","The owner’s representatives, inspectors, etc., is the person or team the owner delegates to represent the owner’s interests and carry out owner responsibilities as designated in the contract. This may include items such as approving change orders, quality inspections, payments to contractors, quality control, etc.\n"]
["2.2","Has the firm successfully completed projects with this designer (architect/engineer)?","Prior experience with a  project designer, architect or engineer is a significant indicator of a potential successful relationship and includes knowledge about the level of detail and clarity of design documents, type of cooperation the designers offers, the buildability of their designs, etc. Lack of direct experience may be compensated for by knowledge of a designer's reputation, however the user is cautioned that such information is difficult to verify and may have limited reliability.\n"]
["2.3","Has the firm successfully completed projects with this designer’s field personnel, inspectors, etc.?","Has the firm had successful experience with the designer's, architect's or engineer's field representatives, inspectors, and other who may represent the designer’s interests and carry our designer responsibilities? These are usually designated in the contract which may include, but are not limited to: items such as issuing change orders, quality inspections, approving payments, the speed which requests for information and shop drawings are responded to, etc.   \n"]
["2.4","Has the estimating team priced this type of project?","What is the level of experience of the firm’s estimators with similar types of work including similar materials, subcontractors, vendors and labor? The user should take into consideration those who will be preforming the actual estimating for this project.\n"]
["2.5","Has the anticipated or assigned field team (PM, Supt, Foreman) built this type of project?","The likelihood of success is impacted if the field team that will be responsible to construct this project had direct experience building and/or managing this type/size of project. This does not mean “years in construction” but direct hands-on experience with similar type of work.\n"]
["3.1","Is the required project schedule reasonable?","From the experience of the person filling out this form is the duration of the project defined in the contract reasonable? If a duration or completion date is not defined, or the person filling out the form cannot determine if the duration is reasonable, the answer is “unknown”.\n"]
["3.2","Is there sufficient labor available to produce the project?","Is labor availability in the area the project will be built and at the time the project will be constructed going to impact production or schedule? Labor skill level should also be considered. If uncertain answer “unknown”. Achieving unreasonable schedules impacts cost and not achieving them impacts reputation.\n"]
["3.3","Has the Firm had prior successful experience with the intended major subcontractors?","This addresses the level of confidence the firm has in the major subcontractors that will be awarded work on this project. Successful prior experience is a positive as is reputation, however if there are a large number of subcontractors this question is difficult which in itself highlights concerns about unknowns. The less known about subcontractors' performance the greater the exposure.      \n                                             "]
["3.4","Are there unusual access, parking, dust, noise, storage space or traffic issues?","This issue address convenience and ease of operation which can have a huge impact on productivity. For example an inner city project with zero storage space is managed differently that an open-field project just as working in occupied spaces has different exposures and requirements that unoccupied spaces. Access, room-to-work, parking, dust, noise, storage space, traffic issues or others have associated costs and productivity impacts.\n"]
["3.5","Are there obvious or announced unusual ground or surface water conditions?","Obvious and announced ground or water condition can be difficult to estimate which impacts costs and suspecting such conditions does the same. Prior experience in a particular area may offer reasonable knowledge about anticipated conditions which may reduces exposure. If there are no obvious or announced conditions the answered is no. Unknown is a relatively common answer, but would be recommended only if the user had reason to suspect or some doubts about the issue.\n"]
["3.6","Are there rock, soft soils or unusually deep excavations that may complicate or delay the project?","Obvious and announced rock, soil issues or deep excavations may be difficult to estimate which impacts potential success and just suspecting such conditions does the same. Prior experience in an area provides superior knowledge about anticipated conditions reduces risk. Unknowns increase risk. \n"]
["3.7","Are there round/curved walls or roofs that may complicate or delay the project?","Straight lines, squares and rectangles are most common in the built environment and therefore designers and constructors have more experience with them. Conversely fewer have experience with round, curved or oblique angles. A project with unusual, circular, curved or angled design elements: i.e. walls, bridges, roofs, structures, or other may be more complicate than anticipated and/or delayed. Users may want to take into consideration that out-of-the-ordinary designs may impact estimating and/or production in measuring potential success. If the firm has direct prior experience with such issues potential for success is increased.\n"]
["3.8","Are there critical long-lead, sole source or unusual items that may delay the project?","Critical long-lead, unusual or sole source items can seriously impact schedule. At project selection phase little may be known about how long it will take to procure the items so potential success is impacted.. Unknowns increase concern and knowledge reduces it. However, because the user does not have the job yet clarifying these issues may not be practical. In which case caution should be exercised. \n"]
["4.1","Is the owner’s financing in place? ","There is exposure associated with pursuing a project when the owner’s financing is not firmly in placed, however, the exposure at pre-project stage is limited to the cost of pursuing the project. Pre-project potential is being measured up to, but not including, the award of the contract so it is assumed that without financing in place most firm's would not enter into a contract. Some may not expect all financing to be firm at this stage and may base their pursuit on the assumption that it will be by contract award. \n"]
["4.2","Does the organization have experience with the payment processes of this owner?","Project owners vary considerably in payment processes. How long it takes to be paid obviously impacts cash flow and has a cost associated with it which may affect project selection decisions. Experience with an owner’s payment process (good or bad) moves the issue of payment to known which reduces exposure. If a user likes or dislikes the process they can base their pricing and decision on experience. Conversely having no knowledge about an owner’s payment process increases exposure at the project selection stage.\n"]
["4.3","Will this project strain the organization’s capacity? ","An organization’s resources include, but are not limited to, manpower, equipment, financial, management or other. If the firm’s resources are fully committed and outside resources are not available, profit potential will be impacted. Resources from within the firm are known and therefore easier to deploy. If resources must come from outside the firm efficiency and cost may be impacted.\n"]
["5.1","Are contract terms reasonable?","Contract terms impact performance and determining the reasonableness of contract terms is difficult at best. Because most contracts are issued to the firm by the owner, negotiating terms may be difficult to impossible. A firm may need to determine what contract language it is willing to accept and will the cost for any exposure be included in the estimate? This will often be answered “unknown” as contract terms may not be available when a project selection is being made.\n"]
["5.2","Are there any unusual retainage issues that will affect cash flow or unusual bond requirements?","Retainage is a cash flow issue that most firms understand and have dealt with in the past. This question addresses any “unusual” retainage issues that should be considered at pre-project selection stage with an understanding that retainage impacts cash flow.\n"]
["5.3","Are there any unusual insurance requirements?","Bonds obviously have a cost and may impact a firm’s bonding capacity. Unusual or out-of-the-ordinary bond language is becoming more prevalent and can seriously impact project potential. \n"]
["5.4","Are there any unusual indemnity issues? ","Some contracts require the contractor to provide insurance for issues that are difficult or expensive to insure and some have requirements to insure third parties. A contract that requires no additional insurance other than what a firm already caries has low or reasonable exposure. Contracts that requires additional or special insurance or coverage for third parties has greater cost and exposure.\n"]
["5.5",null,"Some contracts require the firm to indemnify others which could expose the firm to becoming responsible for the actions of others which may have serious cost consequences. With no unusual indemnity issues or only those the firm has undertaken in the past many consider the exposure to be “normal” which for these purposes would mean low. Unusual or increased indemnity issues in a contract increase exposure and should be considered in project selection decisions.\n"]