{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DBE Detailed Plan Front Page","DBE Detailed Plan-Non Pay Estim","DBE Detailed Plan Pay Estimate "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"DBE Detailed Plan Front Page","index":0,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[25,0,25,1],[26,0,26,1],[27,0,27,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[19,9,20,9],[17,8,17,9],[17,4,17,5],[6,9,6,10],[39,5,39,9],[9,7,9,9],[11,3,11,9],[14,3,14,9],[14,0,14,1],[9,4,9,6],[19,7,20,7],[9,1,9,3]]}
[]
["KENTUCKY TRANSPORTATION CABINET"]
["DEPARTMENT OF HIGHWAYS"]
["DIVISION OF CONSTRUCTION PROCUREMENT"]
[" DBE Plan/SUBCONTRACT REQUEST"]
["CONTRACT ID (CONTID)"]
["Subcontract # :",null,null,null,null,null,null,null,null,"Page 1 of 3"]
["TO :","Ryan Griffith"]
[null,"Director: Division of Construction Procurement"]
["FROM : ",null,null,null,"1st Tier Subcontractor:"]
[null,"Prime Contractor ",null,null,null,"(if applicable)",null,null,null,null,null,null,null,0]
["SUBJECT :"]
[null,"County",null,"Project Number"]
["I hereby request to utilize for DBE participation a portion of the subject project to:"]
[null,null,"of"]
["DBE Employer Identification Numbers:",null,"Federal",null,"KY "]
["The amount to be subcontracted by this request is            ",null,"DBE",null,"or",{"$f":"IF(D17=0,0,D17/E18)","v":0},"Contract",null,"or",{"$f":"IF(H17=0,0,H17/I18)","v":0},"of the "]
["(original contract ) or a subcontract amount of      ",null,null,null,null,null,"Worth",null,{"$f":"E18","v":0}]
[]
["I have previously requested approval for subcontracts or agreements with other DBE as follows:",null,null,null,null,null,null,"Contract \"Worth\" Amount",null,"Contract  %"]
["Name of DBE firm",null,null,"DBE Amount",null,"DBE %",null,null,null,"Contract %"]
[null,null,null,null,null,{"$f":"IF( D22=0,0,D22/$E$18)","v":0},null,null,null,{"$f":"IF( H22=0,0,H22/$I$18)","v":0}]
[null,null,null,null,null,{"$f":"IF( D23=0,0,D23/$E$18)","v":0},null,null,null,{"$f":"IF( H23=0,0,H23/$I$18)","v":0}]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
["Totals based on original contract Amounts",null,null,{"$f":"SUM(D17:D28)","v":0},null,{"$f":"IF( D29=0,0,D29/E18)","v":0},null,{"$f":"SUM(H17:H28)","v":0},null,{"$f":"IF( H29=0,0,H29/I18)","v":0}]
[]
[]
["This section applicable if DBE firm is also a Subcontractor of work on Project:"]
["This subcontractor has been furnished a copy of Appendix B of 49 CFR Part 29 and advised to include"]
["the Certification in all lower tier covered transactions and in all solicitations for lower tier transactions"]
["(Federal Aid Contracts only)."]
[]
[]
[]
[]
[]
["Prime Contractor's Signature",null,null,null,null,"Date"]
[]
[]
[{"$f":"IF($N$44=1,\"Subcontractor's Signature\",IF($N$44=2,\"1st Tier Subcontractor's Signature(if applicable)\",\"Contractor's Signature\"))","v":"1st Tier Subcontractor's Signature(if applicable)"},null,null,null,null,"Date",null,null,null,null,null,null,null,2]
[]
["DBE Participant Signature",null,null,null,null,null,null,"Date"]

{"sheet":"DBE Detailed Plan-Non Pay Estim","index":1,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,4,45,5],[7,0,7,2],[39,0,39,2],[24,0,24,2],[27,0,27,2],[36,0,36,2],[30,0,30,2],[33,0,33,2],[31,0,31,2],[32,0,32,2],[45,0,45,1],[45,2,45,3],[38,0,38,2],[43,0,43,2],[40,0,40,2],[41,0,41,2],[42,0,42,2],[44,0,44,2],[18,4,20,4],[28,0,28,2],[29,0,29,2],[25,0,25,2],[26,0,26,2],[18,3,20,3],[22,0,22,2],[18,0,20,2],[23,0,23,2],[21,0,21,2],[37,0,37,2],[34,0,34,2],[35,0,35,2],[26,6,26,7],[27,6,27,7],[28,6,28,7],[36,6,36,7],[33,6,33,7],[35,6,35,7],[30,6,30,7],[45,6,45,7],[42,6,42,7],[43,6,43,7],[44,6,44,7],[18,5,20,5],[21,6,21,7],[25,6,25,7],[41,6,41,7],[34,6,34,7],[29,6,29,7],[31,6,31,7],[32,6,32,7],[37,6,37,7],[40,6,40,7],[39,6,39,7],[38,6,38,7],[7,8,7,9],[23,6,23,7],[24,6,24,7],[18,8,20,10],[18,6,20,7],[22,6,22,7],[7,5,7,6]]}
[]
[null,"KENTUCKY TRANSPORTATION CABINET"]
[null,"DEPARTMENT OF HIGHWAYS"]
[null,"DIVISION OF CONSTRUCTION PROCUREMENT"]
[null,"DBE Plan/SUBCONTRACT REQUEST "]
[null,null,null,null,null,null,null,null,null,null,"Page 2 of 3"]
[]
["Contract ID (ContID)",null,null,{"$f":"'DBE Detailed Plan Front Page'!B6","v":0},"Prime",{"$f":"'DBE Detailed Plan Front Page'!B10","v":0},null,"DBE Firm",{"$f":"'DBE Detailed Plan Front Page'!A15","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DBE Participation Non-Pay Estimates Work Items"]
["      Description",null,null,"Total Contract Quantity","Unit","DBE Unit Price","Dollar Amount based on DBE Price",null,"Comments"]
[]
[]
[null,null,null,null,null,null,{"$f":"F22*D22","v":0}]
[null,null,null,null,null,null,{"$f":"F23*D23","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,"Page Total",null,{"$f":"SUM(G22:H45)","v":0}]

{"sheet":"DBE Detailed Plan Pay Estimate ","index":2,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,9,7,10],[7,6,7,7],[17,6,19,6],[7,2,7,5],[17,12,19,12],[17,11,19,11],[17,7,19,7],[17,8,19,8],[17,9,19,9],[17,10,19,10]]}
[]
[null,null,null,null,"                                                                     KENTUCKY TRANSPORTATION CABINET"]
[null,null,null,null,null,null,null,"DEPARTMENT OF HIGHWAYS"]
[null,null,null,null,null,null,"       DIVISION OF CONSTRUCTION PROCUREMENT"]
[null,null,null,null,null,null,null,"                  DBE Plan/SUBCONTRACT REQUEST"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Page 3 of 3  "]
[]
[null,null,"Contract ID (ContID)",null,null,null,{"$f":"'DBE Detailed Plan Front Page'!B6","v":0},null,"DBE Firm",{"$f":"'DBE Detailed Plan Front Page'!A15","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"The Items to be subcontracted are as follows:"]
[null,"Supplier ","Project Control",null,"Project",null,"Unit","Contract Quantity","Contract \"Worth\" Unit Price","Dollar Amount based on Contract Price","DBE Quantity","DBE Unit Price","Dollar Amount based on DBE Price"]
[null,"60% Y/N","(PCN)","Category","Line ","      Description"]
[null,null,"Number","Number","Number"]
[null,null,null,null,null,null,null,null,null,{"$f":"I21*H21","v":0},null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(B21=\"Y\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"H22","v":0},{"$f":"I22","v":0},{"$f":"IF(P22>=2,IF(K22=0,0,K22*L22),(L22*K22)*0.6)","v":0},null,null,{"$f":"IF(B22=\"\",\"\",IF(B22=\"Y\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,0,{"$f":"H23","v":0},{"$f":"I23","v":0},0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"H24","v":0},{"$f":"I24","v":0},0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"H34","v":0},0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,{"$f":"H35","v":0},0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,{"$f":"IF(B45=\"\",\"\",IF(B45=\"Y\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,null,0,0,0,0,null,null,""]
[null,null,null,null,null,null,null,null,"Page Total",{"$f":"SUM(J21:J49)","v":0},null,null,{"$f":"SUM(M21:M49)","v":0}]
[]
[null,null,"Comments:"]