{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["C1_Project_Cost_Basis_(Task)","C2_Utilization_by_Firm_(Vendor)","C3_Rate_Schedule_(Labor)","C4_Unit_Costs_(ODC)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"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":"C1_Project_Cost_Basis_(Task)","index":0,"n_rows":63,"n_cols":7,"rows_kept":63,"cut":false,"hidden":false,"merged":[[29,0,29,1],[38,0,40,5]]}
["Project Cost Basis",null,null,null,null,null,"PRINT: 8.5\" x 11\" OR LARGER; LANDSCAPE; 0.5\" MARGINS; HEADERS/FOOTERS; & FIT ALL COLUMNS ON PAGE"]
[]
[null,"Alameda CTC Agreement No.:","A##-00##-A#",null,null,"Task Budget Reallocation"]
[null,"Prime Consultant Firm:",null,null,null,"Reallocation Request No.:"]
[null,"Date:",null,null,"Prime Consultant Contact"]
[null,null,null,null,"Name:"]
[null,null,null,null,"Email:"]
[null,null,null,null,"Phone:"]
["INSTRUCTIONS:"]
["1. On-call and/or optional tasks should use a task number starting with \"O\" (e.g., O1, O1.1, O2); reallocation requests from such tasks should "]
["be accompanied by a Task Order."]
["2. For task budget reallocation requests: (1) Enter the most current approved totals under Task Totals; and (2) Complete all applicable fields."]
[]
["SECTION I. TASK DETAIL"]
[null,null,null,"Task Budget Reallocation"]
["Task No.","Task Description","Task Totals","Adjustment","Revised Task Totals"]
[1,null,0,null,{"$f":"C17+D17","v":0}]
[2,null,0,null,{"$f":"C18+D18","v":0}]
[3,null,0,null,0]
[4,null,0,null,0]
[5,null,0,null,0]
[6,null,0,null,0]
[7,null,0,null,0]
[8,null,0,null,0]
[9,null,0,null,0]
[10,null,0,null,0]
["O1",null,0,null,0]
["O1.1",null,0,null,{"$f":"C28+D28","v":0}]
["O2",null,0,null,0]
["TOTAL",null,{"$f":"SUM(C17:C29)","v":0},{"$f":"SUM(D17:D29)","v":0},{"$f":"SUM(E17:E29)","v":0}]
[]
["SECTION II. CERTIFICATION AND APPROVAL"]
["This section is only required for any task budget reallocation requests to an executed Agreement."]
["This form may be executed by scanned and emailed signature, and a scanned and emailed signature shall constitute an original for all purposes."]
[]
["Request Justification and Details:"]
[]
["Consultant PM Acknowledgment"]
["By my signature below, I certify that I understand that this request to reallocate the task budget amounts does not impact the total not-to-exceed Agreement amount, and I certify that this form and its attached supporting documents are accurate and complete, and that all information herein is in compliance with the Agreement."]
[]
[]
[]
[]
[]
["Consultant PM Name and Title",null,null,"Consultant PM Signature",null,"Date"]
[]
["Alameda CTC PM's Comments:"]
["Effective Date (REQUIRED):"]
[]
["Alameda CTC PM Approval"]
["I certify that this request is reasonable and all information herein is in compliance with the Agreement; I hereby approve this request."]
[]
[]
[]
["Alameda CTC PM Name and Title",null,null,"Alameda CTC PM Signature",null,"Date"]
[]
["Alameda CTC Contract Compliance"]
[]
[]
[]
["Contracting Officer Name and Title",null,null,"Contracting Officer Signature",null,"Date"]
[]
[null,"File: \n • Document Controls\n • Project Controls"]

{"sheet":"C2_Utilization_by_Firm_(Vendor)","index":1,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[[39,0,41,4]]}
["Consultant and Subconsultant Budget",null,null,null,null,null," PRINT: 8.5\" x 11\" OR LARGER; LANDSCAPE; 0.5\" MARGINS; HEADERS/FOOTERS; & FIT ALL COLUMNS ON PAGE"]
[]
["Alameda CTC Agreement No.:","A##-00##-A#","Prime Consultant Firm:",null,null,"Date:"]
[]
["INSTRUCTIONS:"]
["1. Complete DBE Total if DBE Program applies, or LBE and SLBE Totals if LBCE Program applies.",null,null,null,"Vendor Budget Reallocation"]
["2. All firms listed should have rates and/or unit costs reflected in Forms C3 and/or C4.",null,null,null,null,"Reallocation Request No.:"]
["3. For vendor budget reallocation requests:",null,null,null,"Prime Consultant Contact"]
["(1) Enter the most current approved totals under Budget Totals; ",null,null,null,"Name:"]
["(2) Enter the Contract Goal from the Agreement; and ",null,null,null,"Email:"]
["(3) Complete all applicable fields.",null,null,null,"Phone:"]
["4. For vendors (of any tier) not currently identified in Appendix B of the Agreement, the Prime Consultant must also submit:"]
["(1) Form C3 and/or C4 as applicable; and"]
["(2) All supporting documentation from subconsultants/vendors as was required for Agreement execution."]
[]
["SECTION I. VENDOR DETAIL"]
[null,null,null,null,null,"Vendor Budget Reallocation"]
["Vendor Name\n(List Order: Prime Consultant then Subconsultants alphabetically)","Vendor Tier","Business Enterprise Certification","Budget Totals","Adjustment","Revised Budget Totals","Proposed New Vendor?\n(\"Add\")"]
[null,"E.g.:\n• Prime\n• Tier 1 (under Prime)\n• Tier 2 under SubconsultantName","E.g.:\n• LBE\n• LBE and SLBE\n• DBE",0,null,{"$f":"D19+E19","v":0}]
[null,null,null,0,null,{"$f":"D20+E20","v":0}]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,null,0,null,0]
[null,null,"TOTAL:",{"$f":"SUM(D19:D27)","v":0},{"$f":"SUM(E19:E27)","v":0},{"$f":"SUM(F19:F27)","v":0},"Contract Goal (%)"]
[null,null,"DBE Total:",{"$f":"(SUMIF(C20:C27,\"*DBE*\",D20:D27))/$D28","v":{"$error":"#DIV/0!"}},{"$f":"F29-D29","v":{"$error":"#DIV/0!"}},{"$f":"(SUMIF(C20:C27,\"*DBE*\",F20:F27))/$F28","v":{"$error":"#DIV/0!"}},"E.g., \"__._%\" or \"N/A\""]
[null,null,"LBE Total:",{"$f":"(SUMIF(C20:C27,\"*LBE*\",D20:D27))/$D28","v":{"$error":"#DIV/0!"}},{"$f":"F30-D30","v":{"$error":"#DIV/0!"}},{"$f":"(SUMIF(C20:C27,\"*LBE*\",F20:F27))/$F28","v":{"$error":"#DIV/0!"}},"E.g., \"70.0%\" or \"N/A\""]
[null,null,"SLBE Total:",{"$f":"(SUMIF(C20:C27,\"*SLBE*\",D20:D27))/$D28","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(SUMIF(C20:C27,\"*SLBE*\",F20:F27))/$F28","v":{"$error":"#DIV/0!"}},"E.g., \"30.0%\" or \"N/A\""]
[]
["SECTION II. CERTIFICATION AND APPROVAL"]
["This section is only required for any vendor budget reallocation requests to an executed Agreement."]
["This form may be executed by scanned and emailed signature, and a scanned and emailed signature shall constitute an original for all purposes."]
[]
["Request Justification and Details:"]
[]
["Consultant PM Acknowledgment and Certification"]
["By my signature below, I certify that I understand that this request to reallocate the vendor budget amounts does not impact the total not-to-exceed Agreement amount, and I certify that this form and its attached supporting documents are accurate and complete, and that all information herein is in compliance with the Agreement."]
[]
[]
[]
[]
[]
["Consultant PM Name and Title",null,"Consultant PM Signature",null,"Date"]
[]
["Alameda CTC PM's Comments:"]
[]
[]
[]
["Effective Date (REQUIRED):"]
[]
["Alameda CTC PM Approval"]
["I certify that this request is reasonable and all information herein is compliant with the Agreement; I hereby approve this request."]
[]
[]
[]
["Alameda CTC PM Name and Title",null,"Alameda CTC PM Signature",null,"Date"]
[]
["Alameda CTC Contract Compliance"]
[]
[]
[]
["Contracting Officer Name and Title",null,"Contracting Officer Signature",null,"Date"]
[]
["File: \n • Document Controls\n • Project Controls"]

{"sheet":"C3_Rate_Schedule_(Labor)","index":2,"n_rows":74,"n_cols":14,"rows_kept":74,"cut":false,"hidden":false,"merged":[[49,0,49,3],[57,0,57,3],[48,5,49,13]]}
["Consultant and Subconsultant Fixed Hourly Rate Schedule and Key Personnel",null,null,null,null,null,null,null,null,null,null,null,null," PRINT: 11\" x 17\" OR LARGER; LANDSCAPE; 0.5\" MARGINS; HEADERS/FOOTERS; & FIT ALL COLUMNS ON PAGE"]
[]
["Alameda CTC Agreement No.:","A##-00##-A#","Prime Consultant Firm:",null,null,null,"Date:",null,null,null,null,null,"Staff Labor Approval"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Approval Request No.:"]
["INSTRUCTIONS:",null,null,null,null,null,null,null,null,null,null,"Prime Consultant Contact"]
["1. For named employees and key personnel, fields for Personnel Name and Classification/Job Title are required. Add an asterisk (*) by Personnel Name to denote Key Personnel, per",null,null,null,null,null,null,null,null,null,null,"Name:"]
["the Agreement. For classifications only, enter \"Classification Maximum\" under the Personnel Name field, and enter the maximum Direct Salary Rate for that classification under the",null,null,null,null,null,null,null,null,null,null,"Email:"]
["Classification/Job Title field. Reimbursement shall be based on actual direct salary rates up to the maximum rate approved for each classification."]
["2. Include the full roster of personnel for the entire Agreement (all personnel that are listed, have performed work, and/or are being proposed to be added or modified).",null,null,null,null,null,null,null,null,null,null,"Phone:"]
["3. For each individual not currently listed in the Agreement, and is being proposed to be added the Agreement through this request, Consultant is required to: "]
["(1) Use the Direct Salary Rate from the date of entering the Agreement or the date of this request if the individual was not employed with the firm when the Agreement was executed;"]
["(2) Attach certified payroll information or offer letter as supporting documentation; and"]
["(3) Enter \"Added\" in the Proposed Change column."]
["4. For vendors (of any tier) not currently identified in Appendix B of the Agreement, the Prime Consultant must also submit:"]
["(1) Form C2 and/or C4 as applicable; and"]
["(2) All supporting documentation from subconsultants/vendors as was required for Agreement execution."]
["5. For prevailing wage work, please: "]
["(1) Attach proof of Public Works Contractor Registration with the California Department of Industrial Relations (www.DIR.ca.gov) for the Prime Contractor, and the firm(s) performing the prevailing wage work; and"]
["(2) Attach Exhibit 10-H4 from the California Department of Transportation Local Assistance Procedures Manual (LAPM) Forms (http://www.dot.ca.gov/hq/LocalPrograms/lam/forms/lapmforms.htm)."]
[]
["SECTION I. SCHEDULE DETAIL"]
[]
["Vendor Name\n(List Order: Prime Consultant then Subconsultants alphabetically)","Personnel Name\n(List Order: Alphabetical)","Classification/Job Title","Proposed Change\n(\"Add\" or \"Modify\")","Direct Salary Rate\n($)","Fringe Rate\n(%)","Overhead \nRate\n(%)","Combined Indirect Cost Rate\n(%)","Profit\n(%)","Salary Cost Factor","Fixed Hourly Rate\n($)\nEffective Period\nMM/DD/YY-MM/DD/YY","Fixed Hourly Rate\n($)\nEffective Period\nMM/DD/YY-MM/DD/YY","Fixed Hourly Rate\n($)\nEffective Period\nMM/DD/YY-MM/DD/YY","Annual Escalation Rate\n(%)"]
[null,null,null,null,null,null,null,{"$f":"SUM(F24:G24)","v":0},null,{"$f":"+K24/E24","v":{"$error":"#DIV/0!"}},{"$f":"E24+(E24*G24)+(E24*F24)+(SUM(E24+(E24*G24)+(E24*F24))*I24)","v":0},{"$f":"K24*(1+$N24)","v":0},0]
[null,null,null,null,null,null,null,0,null,{"$f":"+K25/E25","v":{"$error":"#DIV/0!"}},{"$f":"E25+(E25*G25)+(E25*F25)+(SUM(E25+(E25*G25)+(E25*F25))*I25)","v":0},0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(F37:G37)","v":0},null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[null,null,null,null,null,null,null,0,null,{"$error":"#DIV/0!"},0,0,0]
[]
["SECTION II. CERTIFICATION AND APPROVAL"]
["This section is required for any request for new personnel to be added to an executed Agreement."]
["This form may be executed by scanned and emailed signature, and a scanned and emailed signature shall constitute an original for all purposes."]
[]
["Consultant PM Certification",null,null,null,null,"Consultant Request Justification and Details (e.g., including, but not limited to: project or scope needs being addressed; budget increase and impact; and what the individual brings to the contract):"]
["By my signature below, I certify that this form and its attached supporting documents are accurate and complete, the rates are reasonable, the staff are qualified, and all information herein is in compliance with the Agreement; I hereby submit the rates and staff marked as \"Proposed Change\" for approval."]
[]
[]
[]
[]
["Consultant PM Name and Title",null,"Consultant PM Signature","Date"]
[]
["Alameda CTC PM Approval",null,null,null,null,"Alameda CTC Comments:"]
["By my signature below, I certify that the attached supporting documents are accurate and complete, the rates are reasonable, the staff are qualified, and all information herein is in compliance with the Agreement; I hereby approve the rates and staff marked as \"Proposed Change\" for payment."]
[]
[]
[]
[]
["Alameda CTC PM Name and Title",null,"Alameda CTC PM Signature","Date"]
[]
["Alameda CTC Contract Compliance"]
[]
[]
[]
[]
["Contracting Officer Name and Title",null,"Contracting Officer Signature","Date"]
[]
["File: "]
[" • Document Controls"]
[" • Project Controls"]

{"sheet":"C4_Unit_Costs_(ODC)","index":3,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[34,0,34,7]]}
["Consultant and Subconsultant Unit Costs",null,null,null,null,null,null," PRINT: 8.5\" x 11\" OR LARGER; LANDSCAPE; 0.5\" MARGINS; HEADERS/FOOTERS; & FIT ALL COLUMNS ON PAGE"]
[]
[null,"Alameda CTC Agreement No.:","A##-00##-A#",null,null,"Unit Costs Approval"]
[null,"Prime Consultant Firm:",null,null,null,null,"Approval Request No.:"]
[null,"Date:",null,null,null,"Prime Consultant Contact"]
[null,null,null,null,null,"Name:"]
["INSTRUCTIONS:",null,null,null,null,"Email:"]
["1. The Section I table is required for unit costs or direct costs to be included in the Agreement.",null,null,null,null,"Phone:"]
["2. These costs should be competitive in their respective industries and supported with appropriate documentation."]
["3. Include the full list of unit costs for the entire Agreement (all unit costs listed, incurred, and/or proposed)."]
["4. For vendors (of any tier) not currently identified in Appendix B of the Agreement, the Prime Consultant must also submit:"]
["(1) Form C2 and/or C3 as applicable; and"]
["(2) All supporting documentation from subconsultants/vendors as was required for Agreement execution."]
[]
["SECTION I. COSTS DETAIL"]
[]
["Task No.","Vendor Name\n(List Order: Prime Consultant then Subconsultants alphabetically)","Vendor Tier","Description","Quantity","Unit","Unit Cost","Total"]
[1,null,"E.g.:\n• Prime\n• Tier 1 (under Prime)\n• Tier 2 under SubconsultantName","E.g.:\n72-hour continuous midweek video average daily traffic (ADT) counts; 4 midweek locations (2 EB/2 WB) @ $1,238 per location",4,"Per Location",1238,{"$f":"E18*G18","v":4952}]
[2]
[3]
[4]
[5]
[6]
["O1"]
["O2"]
[]
["SECTION II. CERTIFICATION AND APPROVAL"]
["This section is only required for any request for approval of direct costs to an executed Agreement."]
["This form may be executed by scanned and emailed signature, and a scanned and emailed signature shall constitute an"]
["original for all purposes."]
[]
["Request Justification and Details:"]
[]
["Consultant PM Acknowledgment"]
["By my signature below, I certify that I understand that this request does not impact the total not-to-exceed Agreement amount, and I certify that this form is accurate and complete, the costs are reasonable, the vendors are qualified, and all information herein is in compliance with the Agreement."]
[]
[]
["Consultant PM Name and Title",null,null,"Consultant PM Signature",null,null,"Date"]
[]
["Alameda CTC PM's Comments:"]
[]
[]
["Alameda CTC PM Approval"]
["I certify that this form is accurate and complete, this request is reasonable, and all information herein is compliant with the Agreement; I hereby approve this request."]
[]
[]
["Alameda CTC PM Name and Title",null,null,"Alameda CTC PM Signature",null,null,"Date"]
[]
["Alameda CTC Contract Compliance"]
[]
[]
["Contracting Officer Name and Title",null,null,"Contracting Officer Signature",null,null,"Date"]
[]
[null,"File: \n • Document Controls\n • Project Controls"]