{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","OTHER DIRECT COSTS","ICE vs Cost Proposal","Cost Analysis Notes","Final Neg Memo"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":1,"defined_names":7,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"OTHER DIRECT COSTS","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,1,8,7],[1,1,1,7],[2,1,2,7],[3,1,3,7],[0,1,0,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7]]}
[null,"COST ANALYSIS  (Part 2)\n(OTHER DIRECT COSTS)"]
["Local Agency :",{"$f":"+'[1]LPA Estimate of Hours'!B2","v":{"$error":"#REF!"}}]
["Project Name :",{"$f":"+'[1]LPA Estimate of Hours'!B3","v":{"$error":"#REF!"}}]
["Project Location :",{"$f":"+'[1]LPA Estimate of Hours'!B4","v":{"$error":"#REF!"}}]
["Control No. :",{"$f":"+'[1]LPA Estimate of Hours'!B5","v":{"$error":"#REF!"}}]
["Local Agency Responsible Charge :",{"$f":"+'[1]LPA Estimate of Hours'!B6","v":{"$error":"#REF!"}}]
["Phone :",{"$f":"+'[1]LPA Estimate of Hours'!B7","v":{"$error":"#REF!"}}]
["E-mail :",{"$f":"+'[1]LPA Estimate of Hours'!B8","v":{"$error":"#REF!"}}]
["Date :",{"$f":"+'[1]LPA Estimate of Hours'!B9","v":{"$error":"#REF!"}}]

{"sheet":"ICE vs Cost Proposal","index":2,"n_rows":81,"n_cols":18,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["COST ANALYSIS - Part 2\n(ICE vs Cost Proposal)"]
["Local Agency :",{"$f":"+'OTHER DIRECT COSTS'!B2","v":{"$error":"#REF!"}}]
["Project Name :",{"$f":"+'OTHER DIRECT COSTS'!B3","v":{"$error":"#REF!"}}]
["Project Location :",{"$f":"+'OTHER DIRECT COSTS'!B4","v":{"$error":"#REF!"}}]
["Control No. :",{"$f":"+'OTHER DIRECT COSTS'!B5","v":{"$error":"#REF!"}}]
["Local Agency Responsible Charge :",{"$f":"+'OTHER DIRECT COSTS'!B6","v":{"$error":"#REF!"}}]
["Phone :",{"$f":"+'OTHER DIRECT COSTS'!B7","v":{"$error":"#REF!"}}]
["E-mail :",{"$f":"+'OTHER DIRECT COSTS'!B8","v":{"$error":"#REF!"}}]
["Date :",{"$f":"+'OTHER DIRECT COSTS'!B9","v":{"$error":"#REF!"}}]
["a"]
["a",null,null,null,null,null,"CONSULTANT:",{"$f":"+'OTHER DIRECT COSTS'!G12","v":0},null,null,null,"Acceptable % (+/-)"]
["Direct Costs\n","Local Agency (ICE)",null,null,"Prime/\nSub",null,"Consultant Cost Proposal",null,null,"Acceptable",null,"Acceptable Range\n(Rate $)",null,null,null,"Final Negotiation"]
["Title","Hours","Rate","Amount","P/S",null,"Hours","Rate","Amount","(Yes/Negotiate)",null,"Low","High",null,null,"Hours","Rate","Amount"]
[null,null,null,{"$f":"B14*C14","v":0},null,null,null,null,{"$f":"G14*H14","v":0},{"$f":"IF(H14=0,\"\",IF(H14<=L14,\"YES\",IF(H14<=M14,\"YES\",IF(H14>M14,\"Negotiate\"))))","v":""},null,{"$f":"+C14*(1-$N$11)","v":0},{"$f":"+C14*(1+$N$11)","v":0},null,null,null,null,{"$f":"P14*Q14","v":0}]
[null,null,null,{"$f":"B15*C15","v":0},null,null,null,null,{"$f":"G15*H15","v":0},{"$f":"IF(H15=0,\"\",IF(H15<=L15,\"YES\",IF(H15<=M15,\"YES\",IF(H15>M15,\"Negotiate\"))))","v":""},null,0,0,null,null,null,null,{"$f":"P15*Q15","v":0}]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,{"$f":"+C46*(1-$N$11)","v":0},{"$f":"+C46*(1+$N$11)","v":0},null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0,"",null,0,0,null,null,null,null,0]
["Double click HERE to insert rows;  Ctrl + d to delete rows","TOTAL \n(Direct Costs)",null,{"$f":"SUM(INDIRECT(\"D14:D\"&ROW()-1))","v":0},null,null,"TOTAL (Direct Costs)",null,{"$f":"SUM(INDIRECT(\"I14:I\"&ROW()-1))","v":0},null,null,null,null,null,null,"TOTAL (Direct Costs)",null,{"$f":"SUM(INDIRECT(\"R14:R\"&ROW()-1))","v":0}]
["DELETE Row  CRTL+SHIFT+D","a"]
[null,"a"]
["OTHER DIRECT COSTS (ODC)",null,null,"Amount",null,null,"Other Direct Costs (ODC)",null,"Amount",null,null,null,null,null,null,"OTHER DIRECT COSTS (ODC)",null,"Amount"]
["Printing and Reproduction:",null,null,{"$f":"IFERROR(VLOOKUP(A68,'OTHER DIRECT COSTS'!A16:D105,4,),0)","v":0},null,null,"Printing and Reproduction:",null,{"$f":"IFERROR(VLOOKUP(G68,'OTHER DIRECT COSTS'!A16:H103,8,),0)","v":0},null,null,null,null,null,null,"Printing and Reproduction:",null,{"$f":"IFERROR(VLOOKUP(P68,'OTHER DIRECT COSTS'!A16:L103,12,),0)","v":0}]
["Mileage/Travel:",null,null,{"$f":"IFERROR(VLOOKUP(A69,'OTHER DIRECT COSTS'!A17:D106,4,),0)","v":0},null,null,"Mileage/Travel:",null,{"$f":"IFERROR(VLOOKUP(G69,'OTHER DIRECT COSTS'!A17:H104,8,),0)","v":0},null,null,null,null,null,null,"Mileage/Travel:",null,{"$f":"IFERROR(VLOOKUP(P69,'OTHER DIRECT COSTS'!A17:L104,12,),0)","v":0}]
["Lodging/ Meals:",null,null,{"$f":"IFERROR(VLOOKUP(A70,'OTHER DIRECT COSTS'!A18:D107,4,),0)","v":0},null,null,"Lodging/ Meals:",null,{"$f":"IFERROR(VLOOKUP(G70,'OTHER DIRECT COSTS'!A18:H105,8,),0)","v":0},null,null,null,null,null,null,"Lodging/ Meals:",null,{"$f":"IFERROR(VLOOKUP(P70,'OTHER DIRECT COSTS'!A18:L105,12,),0)","v":0}]
["Other Miscellaneous Costs:",null,null,{"$f":"IFERROR(VLOOKUP(A71,'OTHER DIRECT COSTS'!A19:D108,4,),0)","v":0},null,null,"Other Miscellaneous Costs:",null,{"$f":"IFERROR(VLOOKUP(G71,'OTHER DIRECT COSTS'!A19:H106,8,),0)","v":0},null,null,null,null,null,null,"Other Miscellaneous Costs:",null,{"$f":"IFERROR(VLOOKUP(P71,'OTHER DIRECT COSTS'!A19:L106,12,),0)","v":0}]
[null,"TOTAL \n(Other Direct Costs)",null,{"$f":"SUM(D68:D71)","v":0},null,null,"TOTAL (ODC)",null,{"$f":"SUM(I68:I71)","v":0},null,null,null,null,null,null,"TOTAL (ODC)",null,{"$f":"SUM(R68:R71)","v":0}]
[null,"A","A","A"]
[null,"A","A","A"]
["TOTAL PROJECT COSTS",null,null,"Amount",null,null,"TOTAL PROJECT COST",null,"Amount",null,null,null,null,null,null,"TOTAL PROJECT COST",null,"Amount"]
["Direct Costs",null,null,{"$f":"+D64","v":0},null,null,"Direct Costs",null,{"$f":"+I64","v":0},null,null,null,null,null,null,"Direct Costs",null,{"$f":"R64","v":0}]
["ICR @",null,null,{"$f":"+D76*B77","v":0},null,null,"ICR @",null,{"$f":"+H77*I76","v":0},null,null,null,null,null,null,"ICR @",0,{"$f":"Q77*R76","v":0}]
["Fixed Fee @",null,null,{"$f":"(D76+D77)*B78","v":0},null,null,"Fixed Fee @",null,{"$f":"(I76+I77)*H78","v":0},null,null,null,null,null,null,"Fixed Fee @",0,{"$f":"(R76+R77)*Q78","v":0}]
["Escalation rate",null,null,{"$f":"D76*B79","v":0},null,null,"Escalation rate",null,{"$f":"H79*I76","v":0},null,null,null,null,null,null,"Escalation rate",0,{"$f":"Q79*R76","v":0}]
["Other Direct Costs (ODC)",null,null,{"$f":"+D72","v":0},null,null,"Other Direct Costs (ODC)",null,{"$f":"+I72","v":0},null,null,null,null,null,null,"Other Direct Costs (ODC)",null,{"$f":"R72","v":0}]
[null,"TOTAL\n PROJECT COST",null,{"$f":"SUM(D76:D80)","v":0},null,null,"PROJECT COST",null,{"$f":"SUM(I76:I80)","v":0},null,null,null,null,null,null,"TOTAL PROJECT COST",null,{"$f":"SUM(R76:R80)","v":0}]

{"sheet":"Cost Analysis Notes","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,1,8,4],[0,0,0,4],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4]]}
["COST ANALYSIS"]
["Local Agency:",{"$f":"+'OTHER DIRECT COSTS'!B2","v":{"$error":"#REF!"}}]
["Project Name:",{"$f":"+'OTHER DIRECT COSTS'!B3","v":{"$error":"#REF!"}}]
["Project Location:",{"$f":"+'OTHER DIRECT COSTS'!B4","v":{"$error":"#REF!"}}]
["Control No.:",{"$f":"+'OTHER DIRECT COSTS'!B5","v":{"$error":"#REF!"}}]
["Local Agency Responsible Charge:",{"$f":"+'OTHER DIRECT COSTS'!B6","v":{"$error":"#REF!"}}]
["Phone:",{"$f":"+'OTHER DIRECT COSTS'!B7","v":{"$error":"#REF!"}}]
["E-mail: ",{"$f":"+'OTHER DIRECT COSTS'!B8","v":{"$error":"#REF!"}}]
["Date:",{"$f":"+'OTHER DIRECT COSTS'!B9","v":{"$error":"#REF!"}}]
[]
[]
["NOTES:"]

{"sheet":"Final Neg Memo","index":4,"n_rows":73,"n_cols":12,"rows_kept":73,"cut":false,"hidden":false,"merged":[[20,0,21,0],[20,1,20,3],[0,0,0,3],[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3]]}
["NEGOTIATION SUMMARY"]
["Local Agency:",{"$f":"+'OTHER DIRECT COSTS'!B2","v":{"$error":"#REF!"}}]
["Project Name:",{"$f":"+'OTHER DIRECT COSTS'!B3","v":{"$error":"#REF!"}}]
["Project Location:",{"$f":"+'OTHER DIRECT COSTS'!B4","v":{"$error":"#REF!"}}]
["Control No./ Project No. :",{"$f":"+'OTHER DIRECT COSTS'!B5","v":{"$error":"#REF!"}}]
["Negotiated by:"]
[]
[]
["Name ",null,"Title",null,null,"Date"]
[]
[]
["Name ",null,"Title",null,null,"Date"]
[]
[]
["Name ",null,"Title",null,null,"Date"]
[]
[]
["Name ",null,"Title",null,null,"Date"]
[]
["Services Negotiated:"]
["Items (Work Categories/Tasks/Labor)","Hours"]
[null,"ICE","Consultant","Final"]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
[null,"     ","     ","     "]
["Total Hours:","     ","     ","     "]
[]
["Total Direct Costs:","     ","     ","     "]
["Overhead Costs:","     ","     ","     "]
["Fixed Fee for Profit:","     ","     ","     "]
["Travel / Direct Costs:","     ","     ","     "]
["Total Cost:","     ","     ","     "]
[]
["Justification for Negotiations:"]
[1,null,null,null,null,null,null,null,null,null,null,"     "]
[2,null,null,null,null,null,null,null,null,null,null,"     "]
[3,null,null,null,null,null,null,null,null,null,null,"     "]
[4,null,null,null,null,null,null,null,null,null,null,"     "]
[5,null,null,null,null,null,null,null,null,null,null,"     "]
[6,null,null,null,null,null,null,null,null,null,null,"     "]
[7,null,null,null,null,null,null,null,null,null,null,"     "]
[8,null,null,null,null,null,null,null,null,null,null,"     "]
["Fixed Fee Rate:      ",null,null,null,null,null,null,null,null,null,null,"     "]
["Travel / Direct Costs:      ",null,null,null,null,null,null,null,null,null,null,"     "]
[null,null,null,null,null,null,null,null,null,null,null,"     "]
["Summary of Negotiations and Action Items:",null,null,null,null,null,null,null,null,null,null,"     "]
[]
[]
[]
[]
[]
[]
[]
["Financial Documentation","In project File (YES/NO)","ICR applied to contract (YES/NO)"]
["ICR: The Consultant's ICR: Documentation supporting the acceptance of the ICR for the most recent fiscal year to be applied to the contract? "]
[]
["Exhibit 10-K for Indirect Cost Rate (ICR) for the most recent fiscal year signed and dated (Per 23 CFR 172.11)?"]
[]
["Fee (profit) %: Negotiated per applicable requirements and reasonable and supportable?"]
[]
[]
["ICR"]
["YES"]
["NO"]