These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 13, 2011

Beginning a “Good Faith Effort”

When construction companies bid on public agency projects in California as a General Contractor, they are often required to advertise to DBE (Disadvantage Business Enterprise) firms in an effort to help these firms become subcontractors on projects. In order to meet this requirement, the general contractor must identify the work required to complete the construction project, and fax or email an advertisement to relevant firms. If this advertisement is not given a “good faith effort”, the general contractor could potential have their bid withdrawn. This VBA project allows a user to fulfill the beginning portion of their “good faith effort” with a couple of clicks. The user can download the database of certified DBEs from the internet to begin the search. Once downloaded, a user form guides the user to finding relevant DBE firms based on location and type of construction project. Once the firms are filtered, the user can then click a button to email and/or fax an invitation to bid the filtered firms. In order to track that the email was sent, and the fax was received, the project records the date and time in a log. The user can then click to create a log that aides them through the final parts of the “good faith effort” which entails physically calling the firms to see if the plan to bid on the project.

No comments:

Post a Comment

Blog Archive