{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Helpful Tips","Cover","Project Desc.","Budget Sum","Pre-Const.","Const.","Non-Const.","MWBE Firm Info","Info pg 2","Participation","LOI Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Helpful Tips","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["HELPFUL TIPS"]
["only tabs highlighted in yellow need information from the developer."]
["enter information in yellow cells.  BLUE will be filled out by the URA"]
["Red corner is a comment with directions"]
["each firm can only be counted once as either MBE or WBE."]

{"sheet":"Cover","index":1,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[45,0,45,1],[0,0,0,1],[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
["Developer: Please fill out only the cells in yellow. "]
[]
["FINAL PLAN"]
["Urban Redevelopment Authority "]
["MINORITY/WOMEN OWNED BUSINESS ENTERPRISE PLAN"]
[]
["Date of Initial Submission to M/WBE Committee:"]
[]
["Date of Approval by M/WBE Committee:"]
[]
[]
[]
["PROJECT NAME:"]
[]
["PROJECT LOCATION:"]
[]
[]
[]
["BUSINESS/DEVELOPER NAME:"]
[]
["BUSINESS/DEVELOPER ADDRESS:"]
[]
[]
[]
["URA PROJECT MANAGER:"]
[]
[]
["CONTACT MWBE:","mwbe@ura.org "]
[]
["PUBLIC AGENCY OF PITTSBURGH:","Urban Redevelopment Authority "]
[null,"412 Blvd of the Allies, Suite 901"]
[null,"Pittsburgh, PA  15219"]

{"sheet":"Project Desc.","index":2,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,2],[4,0,4,2],[2,0,2,2],[6,0,6,2]]}
["In the box below describe the proposed project, including location, size, type of project, and partners in the project. Include a project sources and uses statement.  "]
[]
["PROJECT DESCRIPTION"]
[]
[]
[]
["SOURCES AND USES"]
[]
[]
["Sources:"]
["      1.  Developer Equity"]
["      2.  Government Funding (RACP Grant)"]
["      3.  URA Funding (PDF Loan)"]
["      4.  URA Grants"]
["      5.  PUI QLICI Loans or Other CDE QLICI Loans"]
["      6.  Private Financing"]
["      7.  Gap Financing",null,0]
[]
[null,"Total",{"$f":"SUM(C11:C17)","v":0}]
[]
[]
["Uses:"]
["      1.  Property Acquisition"]
["      2.  Construction Costs"]
["      3.  Non-construction Costs (Less land acquisition)"]
["      4.  Pre-construction Costs"]
[]
[null,"Total",{"$f":"SUM(C23:C26)","v":0}]

{"sheet":"Budget Sum","index":3,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,0,3,4],[4,1,4,4],[6,1,6,4],[7,1,7,4],[4,8,6,8],[4,0,6,0],[4,5,6,5],[4,6,6,6],[4,7,6,7],[15,0,17,0],[7,0,9,0],[13,0,14,0],[13,1,14,4],[13,5,14,5],[10,0,12,0],[15,1,15,4],[17,1,17,4],[16,1,16,4],[18,7,20,7],[20,1,20,4],[18,6,20,6],[9,1,9,4],[10,6,12,6],[13,6,14,6],[10,1,10,4],[12,1,12,4],[7,6,9,6],[7,7,9,7],[7,5,9,5],[10,5,12,5],[15,6,17,6],[15,5,17,5],[18,1,18,4],[18,5,20,5],[19,1,19,4],[22,1,22,4],[21,1,21,4],[0,0,0,8],[5,1,5,4],[8,1,8,4],[11,1,11,4],[10,7,12,7],[7,8,9,8],[10,8,12,8],[13,7,14,7],[13,8,14,8],[15,8,17,8],[18,8,20,8],[18,0,20,0],[15,7,17,7]]}
["PROJECT BUDGET & MBE/WBE PLAN SUMMARY"]
[]
[]
[null,null,null,null,null,"ESTIMATED COST","MBE PLAN","WBE PLAN","MBE/WBE TOTAL PLAN COMMITMENT"]
[" 1.",null,null,null,null,{"$f":"'Pre-Const.'!C18","v":0},{"$f":"'Pre-Const.'!D18","v":0},{"$f":"'Pre-Const.'!E18","v":0},{"$f":"SUM(G5:H7)","v":0}]
[null,"Pre-construction Budget & MBE/WBE Plan"]
[null,"(From Page 4)"]
[" 2.",null,null,null,null,{"$f":"'Const.'!B45","v":0},{"$f":"'Const.'!F45","v":0},{"$f":"'Const.'!I45","v":0},{"$f":"SUM(G8,H8)","v":0}]
[null,"Construction Budget & MBE/WBE Plan"]
[null,"(From Page 5)"]
[" 3.",null,null,null,null,{"$f":"'Non-Const.'!F17","v":0},{"$f":"'Non-Const.'!G17","v":0},{"$f":"'Non-Const.'!H17","v":0},{"$f":"SUM(G11,H11)","v":0}]
[null,"Non-construction Budget & MBE/WBE Plan"]
[null,"(From Page 6)"]
[" 4.","TOTAL PROJECT COST",null,null,null,{"$f":"SUM(F5:F13)","v":0},{"$f":"SUM(G5:G13)","v":0},{"$f":"SUM(H5:H13)","v":0},{"$f":"SUM(I5:I13)","v":0}]
[]
[" 5.",null,null,null,null,{"$f":"'Non-Const.'!F34","v":0},{"$f":"'Non-Const.'!G34","v":0},{"$f":"'Non-Const.'!H34","v":0},{"$f":"SUM(G16,H16)","v":0}]
[" 5.","Post Project MBE/WBE Contracts"]
[null,"(From Page 6)"]
[" 6.",null,null,null,null,null,{"$f":"G14/F14","v":{"$error":"#DIV/0!"}},{"$f":"H14/F14","v":{"$error":"#DIV/0!"}},{"$f":"I14/F14","v":{"$error":"#DIV/0!"}}]
[null,"MBE/WBE PLAN COMMITMENT as a percentage"]
[null,"of Total Project Cost"]
["6a.","MBE/WBE PLAN COMMITMENT AS A PERCENTAGE OF TOTAL PROJECT COST, LESS ACQUISITION & NON-CONSTRUCTION BUDGET, LESS \"NO OPPORTUNITY\"",null,null,null,{"$f":"'Pre-Const.'!C18+'Const.'!B45+'Non-Const.'!F21","v":0},{"$f":"G14/F22","v":{"$error":"#DIV/0!"}},{"$f":"H14/F22","v":{"$error":"#DIV/0!"}},{"$f":"I14/F22","v":{"$error":"#DIV/0!"}}]
[" 7.","City Goals as related to contracting disparity",null,null,null,null,"18%","7%","25%"]

{"sheet":"Pre-Const.","index":4,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,6],[4,0,4,1],[18,0,18,1],[8,0,8,1],[9,0,9,1],[11,0,11,1],[5,0,5,1],[7,0,7,1],[10,0,10,1],[30,0,30,5],[19,0,19,4],[19,5,19,6],[12,0,12,1],[16,0,16,6],[15,0,15,1],[17,0,17,1]]}
["Itemize your pre-construction budget below.  Pre-construction activities include architectural, engineering, legal, development, and other consultant functions carried out prior to the construction phase. In the MBE and WBE Plan columns please enter the amount of each line item allocated to an M/WBE Firm.  "]
[]
["PRE-CONSTRUCTION BUDGET AND MBE/WBE PLAN"]
[]
["Pre-Construction Line Items",null,"TOTAL COST","MBE PLAN","WBE PLAN","MBE/WBE FIRM NAME","MBE/WBE CERT STATUS"]
["CM Pre-Construction"]
["Architectural & Engineering Design"]
["     Structural Eng"]
["     Site/Civil Eng"]
["     Mech/Elec/Plmbg Eng"]
["Administrative Costs"]
["     Estimating Services"]
["     Geotechnical Report"]
["     Phase I Environmental"]
["     Hazardous Materials Survey"]
["     Diversity Coordinator"]
[]
["Total Pre-construction Budget","PERCENTAGE OF TOTAL PROJECT COST,",{"$f":"SUM(C6:C16)","v":0},{"$f":"SUM(D6:D16)","v":0},{"$f":"SUM(E6:E16)","v":0}]
[null,"DBE/MBE/WBE PLAN COMMITMENT AS A",null,"(MBE)","(WBE)"]
["MBE/WBE Plan Commitment as a Percentage of Total Pre-construction Budget",null,null,null,null,{"$f":"(E18+D18)/C18","v":{"$error":"#DIV/0!"}}]

{"sheet":"Const.","index":5,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[49,0,49,8],[48,0,48,8],[2,0,2,8],[0,0,0,8],[7,3,7,8],[9,3,9,5],[12,0,13,0],[3,1,3,5],[9,6,9,8]]}
["Itemize your project's construction budget below.  Under each line in the budget, list the MBE/WBEs that you propose to use to provide construction services or supplies.  You can change line items in the budget by writing over unnecessary line items, or by adding additional rows between rows 41 and 42. In column B & E please type the percentage, 100% for Sub-Contractors and 60% for Suppliers. "]
[]
["CONSTRUCTION BUDGET AND MBE/WBE PLAN"]
["Contract:"]
[]
[]
[]
[null,null,null,"MBE/WBE CONSTRUCTION CONTRACTORS ONLY"]
[null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)"]
["Construction, Line Item, and Cost",null,null,"MBE PORTION",null,null,"WBE PORTION"]
[null,null,null,null,"(multiplier)","(A X B)",null,"(multiplier)","(D X E)"]
[null,null,null,null,"Sub 100%","MBE",null,"Sub 100%","WBE"]
["MBE/WBE Participation",null,"MBE/WBE ","MBE","Supplier","\"Qualified\"","WBE","Supplier","\"Qualified\""]
[null,"Amount","Contractor","Contract",0.6,"Amount","Contract",0.6,"Amount"]
["Building-General Conditions",null,null,null,null,{"$f":"D15*E15","v":0},null,null,{"$f":"G15*H15","v":0}]
["             Gen. Cond: Ongoing/Final Cleaning",null,null,null,null,{"$f":"D16*E16","v":0},null,null,{"$f":"G16*H16","v":0}]
["             Gen. Cond: Site Security",null,null,null,null,0,null,null,{"$f":"G17*H17","v":0}]
["Excavation and Backfill",null,null,null,null,0,null,null,0]
["Caissons & Grade Beams",null,null,null,null,0,null,null,0]
["Plumbing Underground",null,null,null,null,0,null,null,0]
["Block and Brick and Waterproofing",null,null,null,null,0,null,null,0]
["Precast Planks and Gycrete",null,null,null,null,0,null,null,0]
["Steel",null,null,null,null,0,null,null,0]
["Frame",null,null,null,null,0,null,null,0]
["Elevator",null,null,null,null,0,null,null,0]
["Roof ",null,null,null,null,0,null,null,0]
["Windows and Exterior Doors",null,null,null,null,0,null,null,0]
["Plumbing and Plumbing Fixtures",null,null,null,null,0,null,null,0]
["Electric and Electric Fixtures",null,null,null,null,0,null,null,0]
["HVAC",null,null,null,null,0,null,null,0]
["Fire Protection & Fire Alarm",null,null,null,null,0,null,null,0]
["Concrete",null,null,null,null,0,null,null,0]
["Exteriors (EIFS-Siding-Decks)",null,null,null,null,0,null,null,0]
["Insulation and Drywall",null,null,null,null,0,null,null,0]
["Painting",null,null,null,null,0,null,null,0]
["Hardwood Flooring & Ceraminc Tile",null,null,null,null,0,null,null,0]
["Trim and Interior Doors",null,null,null,null,0,null,null,0]
["Kitchens, Vanities, and Countertops",null,null,null,null,0,null,null,0]
["Railings",null,null,null,null,0,null,null,0]
["Bike Racks, Mailboxes, Mirrors, Misc.",null,null,null,null,0,null,null,0]
["Appliances",null,null,null,null,0,null,null,0]
[null,null,null,null,null,0,null,null,0]
[]
["*add rows above this row for additional line items. ",null,null,null,null,0,null,null,0]
["Total MBE/WBE Contractor or Subcontractor",{"$f":"SUM(B15:B41)","v":0},null,{"$f":"F45/B45","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F15:F44)","v":0},{"$f":"I45/B45","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(I15:I41)","v":0}]
["Construction"]
[null,null,null,"(MBE)",null,"(MBE)","(WBE)",null,"(WBE)"]

{"sheet":"Non-Const.","index":6,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":false,"merged":[[10,0,10,4],[14,0,14,4],[15,0,15,4],[20,0,20,4],[32,0,32,4],[30,0,30,4],[31,0,31,4],[11,0,11,4],[12,0,12,4],[13,0,13,4],[21,0,21,4],[18,0,18,7],[16,0,16,4],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[32,8,32,9],[30,8,30,9],[31,8,31,9],[13,8,13,9],[14,8,14,9],[29,8,29,9],[28,8,28,9],[42,0,42,10],[17,0,17,10],[22,0,22,10],[25,0,25,10],[24,8,24,10],[26,0,27,4],[24,0,24,7],[26,8,27,9],[18,8,18,10],[33,8,34,10],[28,0,28,4],[29,0,29,4],[33,5,34,5],[33,6,34,6],[33,7,34,7],[33,0,34,4],[2,0,2,10],[0,0,0,10],[16,8,16,9],[20,8,21,9],[20,6,21,6],[20,7,21,7],[20,10,21,10],[20,5,21,5],[15,8,15,9],[11,8,11,9],[7,0,7,4],[8,0,8,4],[9,0,9,4],[5,0,6,4],[12,8,12,9],[5,8,6,9]]}
["Itemize your project's non-construction expenses.  Under each line in the budget, list the MBE/WBEs that you propose to use to provide the goods and services listed.  Also, list any proposed post-project contracts with MBE/WBE firms that are not included in your project budget (for example, maintenance or purchasing contracts).  Non-construction budget items also include real estate taxes, insurance, construction period interest, acquisition costs, and finance fees."]
[]
["NON-CONSTRUCTION AND POST PROJECT MBE/WBE PLAN SUMMARY"]
[]
[null," "]
["Non-Construction Line Items",null,null,null,null,"TOTAL","MBE","WBE","MBE/WBE FIRM NAME",null,"MBE/WBE"]
[null,null,null,null,null,"COST","PLAN","PLAN",null,null,"CERT STATUS"]
["Soft Cost Contingency*"]
["Developer Overhead and Fees"]
["Construction Contingency*","Construction Budget & DBE/MBE/WBE Plan"]
["Appraisal*","(From Page 5)"]
["Property Acquisition*"]
["Administrative Expenses"]
["Taxes, Permits, Utilities*"]
["Administrative Expenses - Legal","(From Page 6)"]
["Financing Costs*"]
["Total Non-construction Budget","PERCENTAGE OF TOTAL PROJECT COST,",null,null,null,{"$f":"SUM(F8:F16)","v":0},{"$f":"SUM(G8:G16)","v":0},{"$f":"SUM(H8:H16)","v":0},"MBE & WBE Total:",null,{"$f":"G17+H17","v":0}]
[1E+19,null,null,null,null,null,null,null,null,null,null,0,4450]
["MBE/WBE Plan Commitment as a Percentage of Total Non-Construction Budget",null,null,null,null,null,null,null,{"$f":"K17/F17","v":{"$error":"#DIV/0!"}}]
[]
["Total Non-construction Budget","PERCENTAGE OF TOTAL PROJECT COST,",null,null,null,{"$f":"F17-(F16+F14+F12+F11+F10+F8)","v":0},{"$f":"G17","v":0},{"$f":"H17","v":0},"MBE &WBE Total:",null,{"$f":"K17","v":0}]
["Less \"No Opportunity\"","LESS ACQUISITION & NON-CONSTRUCTION"]
["*No opportunity is noted by asterisk in above line items"]
[]
["MBE/WBE Plan Commitment as a Percentage of Total Non-Construction Budget Less \"No Opportunity\"",null,null,null,null,null,null,null,{"$f":"K21/F21","v":{"$error":"#DIV/0!"}}]
[]
["Post-Project MBE/WBE Contracts",null,null,null,null,"TOTAL","MBE","WBE","MBE/WBE FIRM NAME",null,"MBE/WBE"]
[null,null,null,null,null,"COST","PLAN","PLAN",null,"FIRM NAME","CERT STATUS"]
[]
[]
[]
[]
[]
["Total Post-Project MBE/WBE Contracts",null,null,null,null,{"$f":"SUM(F29:F33)","v":0},{"$f":"SUM(G29:G33)","v":0},{"$f":"SUM(H29:H33)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["Page 6 of 11"]

{"sheet":"MWBE Firm Info","index":7,"n_rows":57,"n_cols":1,"rows_kept":57,"cut":false,"hidden":false,"merged":[[59,0,59,4],[55,0,55,3],[56,0,56,3],[50,0,50,3],[51,0,51,3],[52,0,52,3],[54,0,54,3],[49,0,49,3],[33,0,33,3],[34,0,34,3],[37,0,37,3],[38,0,38,3],[39,0,39,3],[40,0,40,3],[41,0,41,3],[43,0,43,3],[44,0,44,3],[45,0,45,3],[48,0,48,3],[32,0,32,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[16,0,16,3],[2,0,2,4],[0,0,0,4],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[15,0,15,3]]}
["Please provide the following information on the minority, or women owned businesses included in your MBE/WBE Plan. Please provide a working email address for all firms listed. If a firm does not have an email address, please note the information as unavailable. "]
[]
["PROPOSED CERTIFIED MBE/WBE FIRMS INCLUDED IN THE PLAN"]
[]
["Name of Firm"]
["Contact Person"]
["Street Address"]
["City, State, Zip Code"]
["Telephone Number"]
["Email Address (Required)"]
["Federal ID # or Social Security #"]
["MBE or WBE"]
["Certification Status"]
[]
[]
["Name of Firm"]
["Contact Person"]
["Street Address"]
["City, State, Zip Code"]
["Telephone Number"]
["Email Address (Required)"]
["Federal ID # or Social Security #"]
["MBE or WBE"]
["Certification Status"]
[]
[]
["Name of Firm"]
["Contact Person"]
["Street Address"]
["City, State, Zip Code"]
["Telephone Number"]
["Email Address (Required)"]
["Federal ID # or Social Security #"]
["MBE or WBE"]
["Certification Status"]
[]
[]
["Name of Firm"]
["Contact Person"]
["Street Address"]
["City, State, Zip Code"]
["Telephone Number"]
["Email Address (Required)"]
["Federal ID # or Social Security #"]
["MBE or WBE"]
["Certification Status"]
[]
[]
["Name of Firm"]
["Contact Person"]
["Street Address"]
["City, State, Zip Code"]
["Telephone Number"]
["Email Address (Required)"]
["Federal ID # or Social Security #"]
["MBE or WBE"]
["Certification Status"]

{"sheet":"Info pg 2","index":8,"n_rows":57,"n_cols":1,"rows_kept":57,"cut":false,"hidden":false,"merged":[[6,0,6,3],[0,0,0,4],[2,0,2,4],[4,0,4,3],[5,0,5,3],[7,0,7,3],[8,0,8,3],[23,0,23,3],[21,0,21,3],[22,0,22,3],[18,0,18,3],[19,0,19,3],[17,0,17,3],[15,0,15,3],[16,0,16,3],[12,0,12,3],[10,0,10,3],[11,0,11,3],[26,0,26,3],[27,0,27,3],[40,0,40,3],[41,0,41,3],[39,0,39,3],[37,0,37,3],[38,0,38,3],[34,0,34,3],[32,0,32,3],[33,0,33,3],[29,0,29,3],[30,0,30,3],[28,0,28,3],[50,0,50,3],[48,0,48,3],[49,0,49,3],[45,0,45,3],[43,0,43,3],[44,0,44,3],[59,0,59,4],[56,0,56,3],[54,0,54,3],[55,0,55,3],[51,0,51,3],[52,0,52,3]]}
["Please provide the following information on the minority, or women owned businesses included in your MBE/WBE Plan"]
[]
["PROPOSED CERTIFIED MBE/WBE FIRMS INCLUDED IN THE PLAN"]
[]
["Name of Firm"]
["Contact Person"]
["Street Address"]
["City, State, Zip Code"]
["Telephone Number"]
["Email Address (Required)"]
["Federal ID # or Social Security #"]
["MBE or WBE"]
["Certification Status"]
[]
[]
["Name of Firm"]
["Contact Person"]
["Street Address"]
["City, State, Zip Code"]
["Telephone Number"]
["Email Address (Required)"]
["Federal ID # or Social Security #"]
["MBE or WBE"]
["Certification Status"]
[]
[]
["Name of Firm"]
["Contact Person"]
["Street Address"]
["City, State, Zip Code"]
["Telephone Number"]
["Email Address (Required)"]
["Federal ID # or Social Security #"]
["MBE or WBE"]
["Certification Status"]
[]
[]
["Name of Firm"]
["Contact Person"]
["Street Address"]
["City, State, Zip Code"]
["Telephone Number"]
["Email Address (Required)"]
["Federal ID # or Social Security #"]
["MBE or WBE"]
["Certification Status"]
[]
[]
["Name of Firm"]
["Contact Person"]
["Street Address"]
["City, State, Zip Code"]
["Telephone Number"]
["Email Address (Required)"]
["Federal ID # or Social Security #"]
["MBE or WBE"]
["Certification Status"]

{"sheet":"Participation","index":9,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[[51,5,54,5],[51,6,54,6],[43,6,46,6],[43,0,46,0],[62,0,62,8],[56,2,56,5],[57,2,57,5],[58,2,58,5],[56,7,56,8],[51,0,54,0],[52,1,52,4],[53,1,53,4],[51,7,54,7],[51,1,51,4],[54,1,54,4],[47,7,50,7],[50,1,50,4],[43,1,43,4],[43,5,46,5],[47,0,50,0],[47,1,47,4],[47,5,50,5],[47,6,50,6],[48,1,48,4],[49,1,49,4],[39,0,42,0],[39,1,39,4],[39,5,42,5],[39,6,42,6],[31,0,34,0],[31,1,31,4],[31,5,34,5],[31,6,34,6],[35,0,38,0],[31,7,34,7],[39,7,42,7],[43,7,46,7],[44,1,44,4],[45,1,45,4],[46,1,46,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[35,5,38,5],[35,6,38,6],[35,7,38,7],[36,1,36,4],[37,1,37,4],[38,1,38,4],[40,1,40,4],[41,1,41,4],[42,1,42,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,0,30,0],[27,1,27,4],[27,5,30,5],[19,6,22,6],[19,7,22,7],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,0,26,0],[23,1,23,4],[23,5,26,5],[23,6,26,6],[23,7,26,7],[19,0,22,0],[19,1,19,4],[19,5,22,5],[27,6,30,6],[27,7,30,7],[28,1,28,4],[29,1,29,4],[30,1,30,4],[16,1,16,4],[15,1,15,4],[12,4,12,6],[12,0,12,3],[8,2,8,3],[8,4,8,5],[9,2,9,3],[8,0,8,1],[15,7,18,7],[14,1,14,4],[17,1,17,4],[18,1,18,4],[15,5,18,5],[15,6,18,6],[15,0,18,0],[0,0,0,8],[9,4,9,5],[2,0,2,8],[3,0,3,8],[5,0,5,1],[5,2,5,7],[7,0,7,1],[7,2,7,3],[7,4,7,5]]}
["Developer: Please fill in all cells.  Compliance reporting forms will be sent to the email address on file. "]
[]
["FORM A"]
["MBE/WBE PARTICIPATION PLAN"]
[]
["PROJECT: "]
[]
["Contractor:",null,null,null,null,null,null,"Bid Amount:"]
["Address:",null,null,null,null,null,null,"Telephone:"]
[null,null,null,null,null,null,null,"Contact:"]
[null,null,null,null,null,null,null,"Email (Required)"]
[]
["Proposed Contract Amount"]
[]
[null,"Company Name, Address, City, State, Zipcode",null,null,null,"MBE/WBE","Total Amount Awarded","Total Percentage","Scope of Work"]
["1."]
[]
[]
[]
["2."]
[]
[]
[]
["3."]
[]
[]
[]
["4."]
[]
[]
[]
["5."]
[]
[]
[]
["6."]
[]
[]
[]
["7."]
[]
[]
[]
["8."]
[]
[]
[]
["9."]
[]
[]
[]
["10."]
[]
[]
[]
[]
["Prepared By:",null,null,null,null,null,null,"         Totals"]
["Title:",null,null,null,null,null,null,"MBE"]
["Date:",null,null,null,null,null,null,"WBE"]
[]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(G16:G55)","v":0}]

{"sheet":"LOI Template","index":10,"n_rows":38,"n_cols":1,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[10,0,10,9],[11,0,11,9],[12,0,12,9],[13,0,13,9],[6,0,6,9],[7,0,7,9],[8,0,8,9],[9,0,9,9],[18,0,18,9],[19,0,19,9],[20,0,20,9],[21,0,21,9],[14,0,14,9],[15,0,15,9],[16,0,16,9],[17,0,17,9],[26,0,26,9],[27,0,27,9],[28,0,28,9],[29,0,29,9],[22,0,22,9],[23,0,23,9],[24,0,24,9],[25,0,25,9],[36,0,36,9],[37,0,37,9],[38,0,38,9],[43,0,43,9],[30,0,30,9],[31,0,31,9],[32,0,32,9],[35,0,35,9],[44,0,44,9],[50,0,50,9],[39,0,39,9],[40,0,40,9],[41,0,41,9],[42,0,42,9]]}
["SAMPLE LETTER OF COMMITMENT"]
[]
[]
["DFG COMPANY"]
[]
[]
[]
[]
["Date"]
[]
[]
["ABC Minority Business Enterprise"]
["1111 Participation Street"]
["Pittsburgh, PA  152xx"]
[]
[]
["Re:  DEF Construction Project No. __________"]
[]
[]
["Attention:  Mr./Mrs./Ms_________________________"]
[]
[]
["I'm writing in reference to the above-mentioned project.  If awarded this project, it is our intent to "]
["enter into an agreement for approximately $___________________ with ABC Minority Business"]
["Enterprise.  If our intentions warrant your interest, please let me know by signing this letter of"]
["intent, and returning it to me by mail, or fax, at your earliest convenience."]
[]
[]
["                                                                                   Sincerely,"]
[]
[]
["                                                                                   ____________________________"]
["                                                                                   DFG Company"]
[]
[]
[]
["_______________________________    Title ______________________  Date_____________"]
["Signed MBE/WBE"]