{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["FormA_PaymentRequest","FormB_VendorCosts","FormC_VendorInfo","FormD_StaffCosts","FormE_RetentionRequest"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":"FormA_PaymentRequest","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[42,4,43,8],[37,0,37,1],[12,0,12,1],[0,0,0,8],[13,0,13,1],[14,0,14,1]]}
["CONSULTANT PAYMENT REQUEST FORM"]
[]
[]
["Prime Consultant:",null,null,"Alameda CTC Agreement No.:",null,null,"Invoice No.:"]
["Address:",null,null,"Alameda CTC Agreement Term:","MM/DD/YY to MM/DD/YY",null,"Date of Invoice:"]
[null,null,null,"Alameda CTC Project Manager:",null,null,"Payment Request No.:"]
["Contact Name:",null,null,"Alameda CTC Project No.:",null,null,"Phase/Description:"]
["Phone:",null,null,"Alameda CTC Project Name:",null,null,"Period (From - To):","MM/DD/YY to MM/DD/YY"]
["E-mail:",null,null,null,null,null,"Final Invoice (YES/NO):"]
[null,null,null,null,null,null,"Exhibit 17-F must be attached with the Final Invoice "]
[null,null,null,null,null,null,"for contracts funded with federal funds."]
["CONSULTANT COSTS"]
["Description",null,"Approved Contract Budget","Billed This Period","Retention Held\nThis Period","Previously Billed","Total Billed to Date","% Expended to Date","Remaining Task Budget"]
["Consultant Charges",null,null,null,null,null,{"$f":"+D14+F14","v":0},{"$f":"IF(G14=0,\"\",G14/C14)","v":""},{"$f":"+C14-G14","v":0}]
["Direct Expenses",null,null,null,null,null,{"$f":"+D15+F15","v":0},{"$f":"IF(G15=0,\"\",G15/C15)","v":""},{"$f":"+C15-G15","v":0}]
[null,"TOTAL CONSULTANT COSTS:",{"$f":"SUM(C14:C15)","v":0},0,0,0,0,{"$f":"IF(G16=0,\"\",G16/C16)","v":""},0]
[]
["TASK BREAKDOWN"]
["Task No.\n(Per the Agreement)","Task Description","Approved Contract Task Budget","Billed this Period","Retention Held\nThis Period","Previously Billed","Total Billed to Date","% Expended to Date","Remaining Task Budget"]
[null,null,null,null,null,null,{"$f":"+D20+F20","v":0},{"$f":"IF(G20=0,\"\",G20/C20)","v":""},{"$f":"+SUM(C20:C20)-G20","v":0}]
[null,null,null,null,null,null,{"$f":"+D21+F21","v":0},{"$f":"IF(G21=0,\"\",G21/C21)","v":""},0]
[null,null,null,null,null,null,{"$f":"+D22+F22","v":0},"",0]
[null,null,null,null,null,null,{"$f":"+D23+F23","v":0},"",0]
[null,null,null,null,null,null,{"$f":"+D24+F24","v":0},"",0]
[null,null,null,null,null,null,{"$f":"+D25+F25","v":0},"",0]
[null,null,null,null,null,null,{"$f":"+D26+F26","v":0},"",0]
[null,null,null,null,null,null,0,"",0]
[null,null,null,null,null,null,{"$f":"+D28+F28","v":0},"",0]
[null,null,null,null,null,null,0,"",0]
[null,null,null,null,null,null,0,"",0]
[null,null,null,null,null,null,0,"",0]
[null,null,null,null,null,null,{"$f":"+D32+F32","v":0},"",0]
[null,null,null,null,null,null,{"$f":"+D33+F33","v":0},"",0]
[null,"TOTAL TASK BREAKDOWN COSTS:",{"$f":"SUM(C20:C33)","v":0},0,0,0,0,"",0]
[]
[]
["Consultant Project Manager's Certification",null,null,null,"ALAMEDA CTC USE ONLY - Reviewer's Comments"]
["I hereby certify that the information included in this Payment Request is true and accurate and that the claimed expenses have been paid as of the date of this request."]
[]
[]
[]
[null,null,null,null,"Alameda CTC Approval"]
["Signature","Date",null,null,"I have reviewed that the supporting documents are accurate and complete, and I approve this invoice for payment."]
[]
[]
[]
[]
["Name and Title",null,null,null,"Signature",null,null,null,"Date"]
[]
["File: \n • Document Controls\n • Project Controls"]

{"sheet":"FormB_VendorCosts","index":1,"n_rows":61,"n_cols":18,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,14],[13,16,14,16],[13,9,14,9],[29,7,30,7],[13,10,14,10],[29,8,30,8],[3,1,3,8],[4,1,4,8],[5,1,5,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[13,7,14,7],[9,1,9,8],[48,0,52,6],[13,1,14,1],[29,0,30,0],[13,2,13,6],[29,1,30,1],[29,2,29,6],[13,0,14,0],[59,11,59,13],[60,11,60,13],[13,17,14,17],[13,15,14,15],[13,14,14,14],[55,11,55,13],[56,11,56,13],[13,12,14,12],[48,15,49,15],[48,14,49,14],[13,13,14,13],[48,11,49,13],[57,11,57,13],[58,11,58,13],[13,11,14,11],[50,11,50,13],[51,11,51,13],[52,11,52,13],[53,11,53,13],[54,11,54,13],[13,8,14,8]]}
["VENDOR COSTS FORM"]
[]
[]
["Prime Consultant:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!B4),\"\",FormA_PaymentRequest!B4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Original Contract Amount ",{"$f":"H27","v":0}]
["Alameda CTC Project No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!E7),\"\",FormA_PaymentRequest!E7)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Amendment No. 1 Amount: "]
["Alameda CTC Agreement No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!E4),\"\",FormA_PaymentRequest!E4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Amendment No. 2 Amount:"]
["Phase/Description:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H7),\"\",FormA_PaymentRequest!H7)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Amendment No. 3 Amount:"]
["Period (From - To):",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H8),\" \",FormA_PaymentRequest!H8)","v":"MM/DD/YY to MM/DD/YY"},null,null,null,null,null,null,null,null,null,null,null,null,"Current Contract Amount:",{"$f":"+P4+P5+P6+P7","v":0}]
["Invoice No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H4),\" \",FormA_PaymentRequest!H4)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"Previously Billed:",{"$f":"K27","v":0}]
["Final Invoice (YES/NO):",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H9),\" \",FormA_PaymentRequest!H9)","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"Amount of this Invoice:",{"$f":"L27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remaining Budget:",{"$f":"P8-P9-P10","v":0}]
[]
["VENDOR COSTS"]
["Vendor Name","Vendor Tier","Certification",null,null,null,null,"Original Vendor Contract Amount","Current Vendor Contract Amount ","% Current Vendor Contract Amount","Previously Billed ","Current Invoice ","Current Retention (Held/Released) ","Total Invoiced to Date ","Total Retention to Date ","Total Paid to Date ","Remaining Amount","% Expended to Date"]
[null,null,"L","S","V","D","W"]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M13),\"\",\"X\")","v":"X"},{"$f":"IF(ISBLANK(FormC_VendorInfo!N13),\"\",\"X\")","v":"X"},{"$f":"IF(ISBLANK(FormC_VendorInfo!O13),\"\",\"X\")","v":"X"},{"$f":"IF(ISBLANK(FormC_VendorInfo!P13),\"\",\"X\")","v":"X"},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q13),\"\",\"X\")","v":"X"},null,null,{"$f":"IF(I16=0,\"\",I16/$I$27)","v":""},null,null,null,{"$f":"+K16+L16","v":0},null,null,{"$f":"+I16-N16","v":0},{"$f":"IF(N16=0,\"0%\",N16/$I16)","v":"0%"}]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M14),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!N14),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!O14),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!P14),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q14),\"\",\"X\")","v":""},null,null,"",null,null,null,0,null,null,0,{"$f":"IF(N17=0,\"0%\",N17/$I17)","v":"0%"}]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M15),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!N15),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!O15),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!P15),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q15),\"\",\"X\")","v":""},null,null,"",null,null,null,0,null,null,0,"0%"]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M16),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!N16),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!O16),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!P16),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q16),\"\",\"X\")","v":""},null,null,"",null,null,null,0,null,null,0,"0%"]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M17),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!N17),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!O17),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!P17),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q17),\"\",\"X\")","v":""},null,null,"",null,null,null,0,null,null,0,"0%"]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M18),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!N18),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!O18),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!P18),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q18),\"\",\"X\")","v":""},null,null,"",null,null,null,0,null,null,0,"0%"]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M19),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!N19),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!O19),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!P19),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q19),\"\",\"X\")","v":""},null,null,"",null,null,null,0,null,null,0,"0%"]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M20),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!N20),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!O20),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!P20),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q20),\"\",\"X\")","v":""},null,null,"",null,null,null,0,null,null,0,"0%"]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M21),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!N21),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!O21),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!P21),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q21),\"\",\"X\")","v":""},null,null,"",null,null,null,0,null,null,0,"0%"]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M22),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!N22),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!O22),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!P22),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q22),\"\",\"X\")","v":""},null,null,"",null,null,null,0,null,null,0,"0%"]
[null,null,{"$f":"IF(ISBLANK(FormC_VendorInfo!M23),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!N23),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!O23),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!P23),\"\",\"X\")","v":""},{"$f":"IF(ISBLANK(FormC_VendorInfo!Q23),\"\",\"X\")","v":""},null,null,"",null,null,null,0,null,null,0,"0%"]
[null,"TOTAL",null,null,null,null,null,{"$f":"SUM(H16:H26)","v":0},{"$f":"SUM(I16:I26)","v":0},"",{"$f":"SUM(K16:K26)","v":0},0,0,0,0,0,0,"0%"]
[]
["SUMMARY OF GOAL PARTICIPATION"]
["Vendor Name","Vendor Tier","Certification",null,null,null,null,"Current Vendor Contract Amount ","Total Paid to Date ","LBE","SLBE","VSLBE","DBE","WDBE"]
[null,null,"L","S","V","D","W",null,null,"Actual To Date","Actual To Date","Actual To Date","Actual To Date","Actual To Date"]
[{"$f":"IF(ISBLANK(A16),\"\",A16)","v":""},"","X","X","X","X","X",{"$f":"IF(ISBLANK(I16),\"\",(I16))","v":""},{"$f":"IF(ISBLANK(P16),\"\",(P16))","v":""},{"$f":"IF(C16=\"X\",I32/$P$27,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(D16=\"X\",I32/$P$27,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(E16=\"X\",I32/$P$27,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(F16=\"X\",I32/$P$27,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(G16=\"X\",I32/$P$27,\"\")","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(ISBLANK(A17),\"\",A17)","v":""},"",{"$f":"IF(ISBLANK(C17),\"\",C17)","v":""},"","","","",{"$f":"IF(ISBLANK(I17),\"\",(I17))","v":""},"","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
["","","","","","","","","","","","","",""]
[null,"TOTAL",null,null,null,null,null,{"$f":"SUM(H32:H42)","v":0},0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"PROJECTED GOAL PER CURRENT VENDOR CONTRACT",null,null,null,null,null,null,null,{"$f":"(IF(C16=\"X\",H32/$I$27,0))+(IF(C17=\"X\",H33/$I$27,0))+(IF(C18=\"X\",H34/$I$27,0))+(IF(C19=\"X\",H35/$I$27,0))+(IF(C20=\"X\",H36/$I$27,0))+(IF(C21=\"X\",H37/$I$27,0))+(IF(C22=\"X\",H38/$I$27,0))+(IF(C23=\"X\",H39/$I$27,0))+(IF(C24=\"X\",H40/$I$27,0))+(IF(C25=\"X\",H41/$I$27,0))+(IF(C26=\"X\",H42/$I$27,0))","v":{"$error":"#VALUE!"}},{"$f":"(IF(D16=\"X\",H32/$I$27,0))+(IF(D17=\"X\",H33/$I$27,0))+(IF(D18=\"X\",H34/$I$27,0))+(IF(D19=\"X\",H35/$I$27,0))+(IF(D20=\"X\",H36/$I$27,0))+(IF(D21=\"X\",H37/$I$27,0))+(IF(D22=\"X\",H38/$I$27,0))+(IF(D23=\"X\",H39/$I$27,0))+(IF(D24=\"X\",H40/$I$27,0))+(IF(D25=\"X\",H41/$I$27,0))+(IF(D26=\"X\",H42/$I$27,0))","v":{"$error":"#VALUE!"}},{"$f":"(IF(E16=\"X\",H32/$I$27,0))+(IF(E17=\"X\",H33/$I$27,0))+(IF(E18=\"X\",H34/$I$27,0))+(IF(E19=\"X\",H35/$I$27,0))+(IF(E20=\"X\",H36/$I$27,0))+(IF(E21=\"X\",H37/$I$27,0))+(IF(E22=\"X\",H38/$I$27,0))+(IF(E23=\"X\",H39/$I$27,0))+(IF(E24=\"X\",H40/$I$27,0))+(IF(E25=\"X\",H41/$I$27,0))+(IF(E26=\"X\",H42/$I$27,0))","v":{"$error":"#VALUE!"}},{"$f":"(IF(F16=\"X\",H32/$I$27,0))+(IF(F17=\"X\",H33/$I$27,0))+(IF(F18=\"X\",H34/$I$27,0))+(IF(F19=\"X\",H35/$I$27,0))+(IF(F20=\"X\",H36/$I$27,0))+(IF(F21=\"X\",H37/$I$27,0))+(IF(F22=\"X\",H38/$I$27,0))+(IF(F23=\"X\",H39/$I$27,0))+(IF(F24=\"X\",H40/$I$27,0))+(IF(F25=\"X\",H41/$I$27,0))+(IF(F26=\"X\",H42/$I$27,0))","v":{"$error":"#VALUE!"}},{"$f":"(IF(G16=\"X\",H32/$I$27,0))+(IF(G17=\"X\",H33/$I$27,0))+(IF(G18=\"X\",H34/$I$27,0))+(IF(G19=\"X\",H35/$I$27,0))+(IF(G20=\"X\",H36/$I$27,0))+(IF(G21=\"X\",H37/$I$27,0))+(IF(G22=\"X\",H38/$I$27,0))+(IF(G23=\"X\",H39/$I$27,0))+(IF(G24=\"X\",H40/$I$27,0))+(IF(G25=\"X\",H41/$I$27,0))+(IF(G26=\"X\",H42/$I$27,0))","v":{"$error":"#VALUE!"}}]
[null,"GOAL",null,null,null,null,null,"-","-",0.7,0.3,0,0,0]
[]
[]
["Reviewer's Comments:",null,null,null,null,null,null,null,null,null,null,"Sub-Consultant Payment Record"]
[null,null,null,null,null,null,null,null,null,null,null,"Vendor Name",null,null,"Date of Last Payment",{"$f":"P14","v":"Total Paid to Date "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(A16),\"\",A16)","v":""},null,null,null,{"$f":"IF(ISBLANK(P16),\"\",(P16))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(ISBLANK(P17),\"\",(P17))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]
["File: ","Vendor Tier",null,null,null,null,null,null,"Vendor Certification",null,null,"",null,null,null,""]
["• Document Controls","P = Prime Contractor",null,null,null,null,null,null,"L = LBE",null,null,"",null,null,null,""]
["• Project Controls","1 = Tier 1 Subconsultant",null,null,null,null,null,null,"S = SLBE",null,null,"",null,null,null,""]
[null,"2 = Tier 2 Subconsultant",null,null,null,null,null,null,"V = VSLBE",null,null,"",null,null,null,""]
[null,"3 = Tier 3 Subconsultant",null,null,null,null,null,null,"D = DBE",null,null,"",null,null,null,""]
[null,null,null,null,null,null,null,null,"W = WBE",null,null,"",null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,""]

{"sheet":"FormC_VendorInfo","index":2,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[10,10,11,10],[10,11,11,11],[10,12,10,16],[0,0,0,16],[10,5,11,5],[10,6,11,6],[10,7,11,7],[10,8,11,8],[10,9,11,9],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4]]}
["VENDOR CONTRACT INFORMATION FORM"]
[]
["This form shall be submitted for each Contract or Contract Amendment, and resubmitted if there is any change to any of the vendor contract information."]
[]
[null,null,null,"Prime Consultant:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!B4),\"\",FormA_PaymentRequest!B4)","v":""}]
[null,null,null,"Alameda CTC Project No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!E7),\"\",FormA_PaymentRequest!E7)","v":""}]
[null,null,null,"Alameda CTC Agreement No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!E4),\"\",FormA_PaymentRequest!E4)","v":""}]
[null,null,null,"Phase/Description:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H7),\"\",FormA_PaymentRequest!H7)","v":""}]
[]
[]
["Vendor ID No.","Vendor Type","Vendor Tier**","Vendor Name","Vendor Address","City","State","Zip","Contact","Phone","Fax","E-mail","Certification Expiration (MM/DD/YY)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LBE","SLBE","VSLBE","DBE","WBE"]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B16),\"\",FormB_VendorCosts!B16)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A16),\"\",FormB_VendorCosts!A16)","v":""},null,null,null,null,null,null,null,null,"MM/DD/YY","MM/DD/YY","MM/DD/YY","MM/DD/YY","MM/DD/YY"]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B17),\"\",FormB_VendorCosts!B17)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A17),\"\",FormB_VendorCosts!A17)","v":""}]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B18),\"\",FormB_VendorCosts!B18)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A18),\"\",FormB_VendorCosts!A18)","v":""}]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B19),\"\",FormB_VendorCosts!B19)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A19),\"\",FormB_VendorCosts!A19)","v":""}]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B20),\"\",FormB_VendorCosts!B20)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A20),\"\",FormB_VendorCosts!A20)","v":""}]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B21),\"\",FormB_VendorCosts!B21)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A21),\"\",FormB_VendorCosts!A21)","v":""}]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B22),\"\",FormB_VendorCosts!B22)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A22),\"\",FormB_VendorCosts!A22)","v":""}]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B23),\"\",FormB_VendorCosts!B23)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A23),\"\",FormB_VendorCosts!A23)","v":""}]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B24),\"\",FormB_VendorCosts!B24)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A24),\"\",FormB_VendorCosts!A24)","v":""}]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B25),\"\",FormB_VendorCosts!B25)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A25),\"\",FormB_VendorCosts!A25)","v":""}]
[null,null,{"$f":"IF(ISBLANK(FormB_VendorCosts!B26),\"\",FormB_VendorCosts!B26)","v":""},{"$f":"IF(ISBLANK(FormB_VendorCosts!A26),\"\",FormB_VendorCosts!A26)","v":""}]
[]
["File: ",null,null,null,"Vendor Type",null,null,null,null,null,"Vendor Tier**"]
["• Document Controls",null,null,null,"A = Agency",null,null,null,null,null,"P = Prime"]
["• Project Controls",null,null,null,"P = Professional Services",null,null,null,null,null,"1 = Tier 1"]
[null,null,null,null,"C = Construction",null,null,null,null,null,"2 = Tier 2"]
[null,null,null,null,"S = Supplier*",null,null,null,null,null,"3 = Tier 3"]
[null,null,null,null,"O = Other"]
[]
[null,null,null,null,"*Supplier is defined as a vendor providing goods or materials not chargeable as a direct expense.",null,null,null,null,null,"**Vendors lower than Tier 1 are only required to be listed if they are used to meet participation goals."]

{"sheet":"FormD_StaffCosts","index":3,"n_rows":75,"n_cols":9,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,0,0,8],[11,3,12,4],[11,5,12,6],[11,7,12,8],[41,5,41,6],[41,7,41,8],[4,1,4,2],[3,1,3,2],[6,1,6,2],[5,1,5,2],[8,1,8,2],[54,5,54,6],[11,1,13,1],[11,0,13,0],[11,2,13,2],[7,1,7,2]]}
["STAFF COSTS FORM FOR LABOR AND DIRECT EXPENSES"]
[]
[]
["Prime Consultant:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!B4),\"\",FormA_PaymentRequest!B4)","v":""}]
["Alameda CTC Project No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!E7),\"\",FormA_PaymentRequest!E7)","v":""}]
["Alameda CTC Agreement No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!E4),\"\",FormA_PaymentRequest!E4)","v":""}]
["Period (From - To):",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H8),\" \",FormA_PaymentRequest!H8)","v":"MM/DD/YY to MM/DD/YY"}]
["Invoice No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H4),\" \",FormA_PaymentRequest!H4)","v":" "}]
["Final Invoice (YES/NO):",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H9),\" \",FormA_PaymentRequest!H9)","v":" "}]
[]
["STAFF LABOR COST SUMMARY"]
["Employee Name","Title","Fully Burdened Billing Rate","This Period",null,"Previously Billed",null,"TOTAL"]
[]
[null,null,null,"Hours","Cost","Hours","Cost","Hours","Total Cost"]
[null,null,0,null,{"$f":"C15*D15","v":0},null,{"$f":"C15*F15","v":0},{"$f":"D15+F15","v":0},{"$f":"E15+G15","v":0}]
[null,null,0,null,{"$f":"C16*D16","v":0},null,{"$f":"C16*F16","v":0},{"$f":"D16+F16","v":0},0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,0,null,0,null,0,0,0]
[null,null,"SUBTOTAL",null,{"$f":"SUM(E15:E38)","v":0},null,{"$f":"SUM(G15:G38)","v":0},null,{"$f":"SUM(I15:I38)","v":0}]
[]
["STAFF DIRECT EXPENSES*"]
["Vendor Name","Description","Invoice No.","Date","This Period","Previously Billed",null,"TOTAL"]
[null,null,null,null,null,null,null,null,{"$f":"E43+G43","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"E44+G44","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,"SUBTOTAL",null,{"$f":"SUM(E43:E52)","v":0},null,{"$f":"SUM(G43:G52)","v":0},null,{"$f":"SUM(I43:I52)","v":0}]
[]
["TOTAL STAFF COSTS",null,null,null,"This Period","Previously Billed",null,null,"TOTAL"]
[null,null,"TOTAL COST",null,{"$f":"E39+E53","v":0},null,{"$f":"G39+G53","v":0},null,{"$f":"I39+I53","v":0}]
[]
[]
["Direct Expenses include, but are not limited to, the following:",null,"Reviewer's Comments:"]
["• Air Travel"]
["• Car Rental"]
["• Computer - Data Processing"]
["• Computer - Word Processing"]
["• Local Travel (Mileage)"]
["• Color Copying"]
["• Photocopying"]
["• Postage/Delivery"]
["• Reprographics/Printing"]
["• Subsistence"]
["• Telephone"]
["• Special Equipment Rental"]
[]
["File: "]
["• Document Controls"]
["• Project Controls"]

{"sheet":"FormE_RetentionRequest","index":4,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[42,4,43,6],[5,1,5,2],[5,5,5,6],[9,1,9,2],[9,5,9,6],[37,0,37,2],[6,1,6,2],[6,5,6,6],[7,1,7,2],[7,5,7,6],[8,1,8,2],[8,5,8,6],[10,5,10,6],[0,0,0,6],[3,1,3,2],[3,5,3,6],[4,1,4,2],[4,5,4,6]]}
["RETENTION RELEASE REQUEST FORM"]
[]
[]
["Prime Consultant:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!B4),\"\",FormA_PaymentRequest!B4)","v":""},null,null,"Alameda CTC Project No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!E7),\"\",FormA_PaymentRequest!E7)","v":""}]
["Address:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!B5),\"\",FormA_PaymentRequest!B5)","v":""},null,null,"Alameda CTC Agreement No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!E4),\"\",FormA_PaymentRequest!E4)","v":""}]
[null,{"$f":"IF(ISBLANK(FormA_PaymentRequest!B6),\"\",FormA_PaymentRequest!B6)","v":""},null,null,"Alameda CTC Manager:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!E6),\"\",FormA_PaymentRequest!E6)","v":""}]
["Contact Name:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!B7),\"\",FormA_PaymentRequest!B7)","v":""},null,null,"Invoice No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H4),\" \",FormA_PaymentRequest!H4)","v":" "}]
["Phone:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!B8),\"\",FormA_PaymentRequest!B8)","v":""},null,null,"Date of Invoice:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H5),\" \",FormA_PaymentRequest!H5)","v":" "}]
["E-mail:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!B9),\"\",FormA_PaymentRequest!B9)","v":""},null,null,"Payment Request No.:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H6),\" \",FormA_PaymentRequest!H6)","v":" "}]
["Retention as of:",null,null,null,"Phase/Description:",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H7),\"\",FormA_PaymentRequest!H7)","v":""}]
[null,null,null,null,"Final Invoice (YES/NO):",{"$f":"IF(ISBLANK(FormA_PaymentRequest!H9),\" \",FormA_PaymentRequest!H9)","v":" "}]
[]
["TOTAL RETENTION WITHHELD:",null,{"$f":"+D34","v":0}]
["RETENTION PREVIOUSLY BILLED:",null,{"$f":"+E34","v":0}]
["OUTSTANDING RETENTION:",null,{"$f":"+C13-C14","v":0}]
["THIS RETENTION RELEASE REQUEST:",null,{"$f":"+F34","v":0}]
["RETENTION BALANCE:",null,{"$f":"+C15-C16","v":0}]
[]
[]
["BILLING AND RETENTION DETAIL"]
["Invoice Number","Invoice Date","Invoice Amount","Retention Withheld","Retention Previously Billed","This Retention Release Request","Retention Balance"]
[null,null,null,null,null,null,{"$f":"+D22-E22-F22","v":0}]
[null,null,null,null,null,null,{"$f":"+D23-E23-F23","v":0}]
[null,null,null,null,null,null,{"$f":"+D24-E24-F24","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,{"$f":"+D33-E33-F33","v":0}]
[null,"TOTAL:",{"$f":"SUM(C22:C33)","v":0},{"$f":"SUM(D22:D33)","v":0},{"$f":"SUM(E22:E33)","v":0},{"$f":"SUM(F22:F33)","v":0},{"$f":"SUM(G22:G33)","v":0}]
[]
[]
["Consultant Project Manager's Certification",null,null,null,"ALAMEDA CTC USE ONLY - Reviewer's Comments"]
["I hereby certify that the information included in this Payment Request is true and accurate and that the claimed expenses have been paid as of the date of this request."]
[]
[]
[]
[null,null,null,null,"Alameda CTC Approval"]
["Signature",null,"Date",null,"I have reviewed that the supporting documents are accurate and complete, and I approve this invoice for payment."]
[]
[]
[]
[]
["Name and Title",null,null,null,"Signature",null,"Date"]
[]
["File: "]
["• Document Controls"]
["• Project Controls"]