{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Invoice Payment Cover Sheet","Invoice Summary","DL & FB","Travel","Equipment","Materials & Miscellaneous","Subs & Vendors","Indirect Costs & Profit","Lists"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":19,"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":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Workbook Instructions",null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
["Enter information as required in all cells highlighted in Blue."]
["All cells not highlighted in Blue are locked from editing.  Locked cells include:  cells with formulas highlighted in Gray or Light Yellow, cells with no color fill (white), etc."]
["Rules for decimal places on values:"]
["·         Budget and Invoice values:"]
["o   Rounding of any values, as described below, should be performed using standard rounding practices."]
["o   For all currency rates (e.g., Direct Labor, and Unit Cost):  Round to the cent ($0.01)."]
["o   For all percentage rates (e.g., Fringe Benefits, Indirect Cost, and Profit):  Round to a maximum of two decimal places of a percent (e.g., 25.12%).  You can round to less if desired, such as one decimal place (e.g., 25.1%), or zero decimal places (e.g., 25%)."]
["o   For all quantity values (e.g., # of hours, # of months, and # of units):  Round to a maximum of two decimal places (e.g., 50.12).  You can round to less if desired, such as one decimal place (e.g., 50.1), or zero decimal places (e.g., 50)."]
["·         Budget values:"]
["o   For entered and totaled (via calculation) CEC and Match share budget values:  Round to the dollar ($1)."]
["o   For all calculated currency values (e.g., rate x hours, rate x months, base amount, and rate x base amount):  Round to the dollar ($1)."]
["·         Invoice values:"]
["o   For entered and totaled (via calculation) CEC and Match share expense invoice values:  Round to the cent ($0.01)."]
["o   For all calculated currency values (e.g., rate x hours, rate x months, base amount, and rate x base amount):  Round to the cent ($0.01)."]
["o   SPECIAL CIRCUMSTANCE for calculated currency values:  ONLY if a calculated value (e.g., rate x hours = actual labor expense) does NOT equal the actual expense, because of the decimal place rules provided for rates and quantity values listed above, it is acceptable to use as many decimal places as necessary for rates and quantity values listed above to ensure that the calculated value DOES equal the actual expense."]
["If additional rows are needed within a section, unhide the hidden rows (i.e., select the row directly above and below the hidden rows, then right-click the selection and select “Unhide”).  Hide any unused rows.  DO NOT USE THE LAST TWO ROWS THAT ARE MARKED “CEC USE ONLY”.  If all but the last 2 rows are used, and more rows are required, please contact the ECAMS Support team (ECAMS.Support@energy.ca.gov)."]
["FOR ECAMS SUPPORT TEAM ONLY:  To add additional rows and maintain the formulas within the totals, (1) unprotect the sheet, (2) copy the second to the last row in the section, (3) insert the copied row just above the last row, (4) repeat steps 2 - 3 as required, (5) correct formatting and REFERRENCE IDs as required, (6) delete “CEC USE ONLY” from all but the last two rows in the section, and (7) re-protect the sheet."]
["For support on how to complete this template, please visit the ECAMS Resources web page.  The link to this web page is provided in the cell below:"]
["https://www.energy.ca.gov/funding-opportunities/funding-resources/ecams-resources"]

{"sheet":"Invoice Payment Cover Sheet","index":1,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,0,43,1],[27,0,27,3],[42,2,42,3],[35,0,35,3],[44,2,44,3],[43,2,43,3],[44,0,44,1],[42,0,42,1]]}
["Invoice Payment Request",null,null,null,null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
[]
["Insert Company Logo"]
[]
["Physical Address:",null,"Bill To:"]
["Company Name",null,"California Energy Commission"]
["Company Address 1",null,"Accounting Office, MS-2"]
["Company Address 2",null,"1516 Ninth Street"]
["City, State, Zip",null,"Sacramento, CA 95814"]
[]
["Remit Payment To:",null,"Agreement Number:","xxx-xx-xxx"]
["Company Name",null,"Invoice Date:","mm/dd/yyyy"]
["Company Address 1",null,"Invoice Number:","ABC-YY-###-##"]
["Company Address 2",null,"Company Tracking Number (optional):","##########"]
["City, State, Zip",null,"Period Covered by Request:","mm/dd/yyyy - mm/dd/yyyy"]
[]
["Federal Tax ID:",null,"Total to Pay This Invoice:",{"$f":"'Invoice Summary'!C39","v":604464.05000000005}]
["##########"]
[]
["CEC Email Address to Submit Invoices",null,"Funding Source Line Items:","Amount:"]
["invoices@energy.ca.gov",null,"1. Grant or Loan Progress Payment.  Amount Only.",{"$f":"D17","v":604464.05000000005}]
[]
[]
[]
[]
[]
["Certification"]
["I certify under penalty of perjury that this invoice is accurate and conforms to the requirements of this agreement.  Reimbursement for these costs has not and will not be received from any other sources.  I have carefully reviewed the terms and conditions for this agreement and have determined that, for work covered by this invoice, the recipient and all subrecipients have complied with all agreement terms, including the requirement of compliance with public works and prevailing wage laws, which when applicable require, among other things, the payment of prevailing wages to eligible workers. All invoice backup documentation (e.g. receipts, invoices, etc.) is available upon request for any items at any time.  All invoiced amounts, including indirect cost rates, are for actual and allowable expenditures under this agreement. "]
[]
[]
[]
[]
["Signature of Authorized Representative     ","Date"]
["Insert Printed Name/Title"]
[]
["For Energy Commission Use Only"]
[]
[]
[]
[]
["CEC Reviewer Signature ","Date"]
[]
["Fi$Cal Purchase Order Number (CGL completes):"]
["Fi$Cal Receipt Number (CGL completes):"]
["Fi$Cal Voucher Number (Accounting completes as-needed):"]

{"sheet":"Invoice Summary","index":2,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[41,0,41,5],[10,0,10,5],[22,0,22,5],[36,0,36,1],[40,0,40,1],[37,0,37,1],[38,0,38,1],[37,3,37,4],[36,3,36,4],[38,3,38,4],[39,3,39,5],[8,1,8,5],[40,3,40,4],[3,2,3,5],[5,2,5,5],[7,2,7,5],[7,0,7,1],[0,0,0,5],[2,0,2,1],[2,2,2,5],[3,0,3,1],[6,2,6,5],[5,0,5,1],[4,0,4,1],[4,2,4,5],[6,0,6,1]]}
["Energy Commission Grant Invoice\nSummary by Category Budget",null,null,null,null,null,null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
[]
["Company Name:",null,{"$f":"'Invoice Payment Cover Sheet'!A6","v":"Company Name"}]
["Agreement Number:",null,{"$f":"'Invoice Payment Cover Sheet'!D11","v":"xxx-xx-xxx"}]
["Invoice Date:",null,{"$f":"'Invoice Payment Cover Sheet'!D12","v":"mm/dd/yyyy"}]
["Invoice Number:",null,{"$f":"'Invoice Payment Cover Sheet'!D13","v":"ABC-YY-###-##"}]
["Company Tracking Number (optional):",null,{"$f":"IF('Invoice Payment Cover Sheet'!D14=\"\",\"\",'Invoice Payment Cover Sheet'!D14)","v":"##########"}]
["Period Covered by this Request:",null,{"$f":"'Invoice Payment Cover Sheet'!D15","v":"mm/dd/yyyy - mm/dd/yyyy"}]
["Retention Method:","Select a Retention Method"]
[]
["CEC Reimbursable Summary"]
["Category","Agreement Reimbursable Budget","Reimbursable Expenses This Period","Cumulative Expenses Billed to Date","% of Reimbursable Spent to Date","Reimbursable Balance"]
["Direct Labor",320500,{"$f":"'DL & FB'!H214","v":10972.9},{"$f":"10972.9+29346.28","v":40319.18},{"$f":"IF($B13=0,0,ROUND($D13,2)/ROUND($B13,0))","v":0.12580087363494541},{"$f":"B13-D13","v":280180.82}]
["Fringe Benefits",179250,{"$f":"'DL & FB'!J214","v":4609.76},{"$f":"4609.75+5976.23","v":10585.98},{"$f":"IF($B14=0,0,ROUND($D14,2)/ROUND($B14,0))","v":5.9057071129707109E-2},{"$f":"B14-D14","v":168664.02}]
["Travel",500,{"$f":"Travel!G54","v":78.63},{"$f":"78.63+29.25","v":107.88},0.21575999999999998,392.12]
["Equipment",657000,{"$f":"Equipment!I207","v":529553.89},{"$f":"529553.89+15367.16","v":544921.05000000005},0.82940799086757999,112078.94999999995]
["Materials/Misc.",35000,{"$f":"'Materials & Miscellaneous'!I207","v":29658.62},{"$f":"29658.62+3216.59","v":32875.21},0.93929171428571423,2124.7900000000009]
["Subs/Vendors",{"$f":"'Subs & Vendors'!D215","v":101000},{"$f":"'Subs & Vendors'!E215","v":21875.33},{"$f":"'Subs & Vendors'!F215","v":32740.46},0.32416297029702967,68259.540000000008]
["Indirect Costs",117051,{"$f":"'Indirect Costs & Profit'!J145","v":6156.65},{"$f":"6156.65+7613.81","v":13770.46},0.11764495818062211,103280.54000000001]
["Profit",49975,{"$f":"'Indirect Costs & Profit'!J156","v":1558.27},{"$f":"1558.27+2364.17","v":3922.44},7.8488044022011011E-2,46052.56]
["Total",{"$f":"SUM(ROUND(B13:B20,0))","v":1460276},{"$f":"SUM(C13:C20)","v":604464.05000000005},{"$f":"SUM(ROUND(D13:D20,2))","v":679242.65999999992},0.46514676677559585,781033.34000000008]
[]
["Match Share Summary"]
["Category","Agreement Match Share Budget","Match Share Expenses This Period","Cumulative Match Share Spent to Date","% of Match Spent to Date","Match Balance"]
["Direct Labor",8000,{"$f":"'DL & FB'!I214","v":2000},{"$f":"2000+256","v":2256},{"$f":"IF($B25=0,0,ROUND($D25,2)/ROUND($B25,0))","v":0.28199999999999997},{"$f":"B25-D25","v":5744}]
["Fringe Benefits",28000,{"$f":"'DL & FB'!K214","v":600},{"$f":"600+6423","v":7023},0.25082142857142858,20977]
["Travel",200,{"$f":"Travel!H54","v":21.56},{"$f":"21.56+26.49","v":48.05},0.24024999999999999,151.94999999999999]
["Equipment",58000,{"$f":"Equipment!J207","v":54452.57},{"$f":"54452.57","v":54452.57},0.93883741379310348,3547.4300000000003]
["Materials/Misc.",10000,{"$f":"'Materials & Miscellaneous'!J207","v":7164.0499999999993},{"$f":"7164.05+1238.19","v":8402.24},0.84022399999999997,1597.7600000000002]
["Subs/Vendors",{"$f":"'Subs & Vendors'!D216","v":71000},{"$f":"'Subs & Vendors'!E216","v":14298.830000000002},{"$f":"'Subs & Vendors'!F216","v":17669.849999999999},0.24887112676056336,53330.15]
["Indirect Costs",8040,{"$f":"'Indirect Costs & Profit'!K145","v":1640.09},{"$f":"1640.09+1749.23","v":3389.3199999999997},0.42155721393034828,4650.68]
["Profit",3600,{"$f":"'Indirect Costs & Profit'!K156","v":260},{"$f":"260+400","v":660},0.18333333333333332,2940]
["Total",{"$f":"SUM(ROUND(B25:B32,0))","v":186840},{"$f":"SUM(C25:C32)","v":80437.099999999991},{"$f":"SUM(ROUND(D25:D32,2))","v":93901.03},0.50257455576964249,92938.97]
[]
["Grand Totals",{"$f":"B21+B33","v":1647116},{"$f":"C21+C33","v":684901.15},{"$f":"D21+D33","v":773143.69},0.46939237430757758,{"$f":"B35-D35","v":873972.31}]
[]
["Reimbursement Total This Period:",null,{"$f":"C21","v":604464.05000000005},"Retention Release Invoice:",null,"Select Yes or No"]
["Retention Amount:",null,{"$f":"IF($B$9=\"Retention is NOT required to be withheld for this agreement\",0,IF($B$9=\"Retention will be withheld from each invoice (minus exempt subrecipients)\",ROUND(($C$37-'Subs & Vendors'!$I$105)*0.1,2),IF(AND($B$9=\"Retention will be withheld at the end of the agreement (minus exempt subrecipients)\",$D$40=\"90.00%, or less, of CEC funds spent to date (minus exempt subrecipients), including this invoice\"),0,IF(AND($B$9=\"Retention will be withheld at the end of the agreement (minus exempt subrecipients)\",$D$40=\"With this invoice, percentage of CEC funds spent (minus exempt subrecipients) will transition from less than to greater than 90.00% [manually enter required retention amount below]\"),ROUND($F$41,2),IF(AND($B$9=\"Retention will be withheld at the end of the agreement (minus exempt subrecipients)\",$D$40=\"More than 90.00% of CEC funds spent to date (minus exempt subrecipients), including this entire invoice\"),ROUND($C$37-'Subs & Vendors'!$I$105,2),0)))))","v":0},"Retention Release Amount:",null,0]
["Total To Be Paid This Invoice:",null,{"$f":"ROUND(C37,2)-ROUND(C38,2)","v":604464.05000000005},"Final Invoice:",null,"Select Yes or No"]
[null,null,null,"If Applicable: \nSelect End of Agreement Retention Method Situation"]
["Match Amount This Period:",null,{"$f":"C33","v":80437.099999999991},"Manual Entry Retention Amount:",null,1000]

{"sheet":"DL & FB","index":3,"n_rows":217,"n_cols":18,"rows_kept":217,"cut":false,"hidden":false,"merged":[[216,0,216,12],[0,0,0,12],[1,0,1,12],[2,0,2,12],[106,0,106,12],[104,0,104,4],[208,0,208,4],[213,0,213,4],[210,0,210,12],[215,0,215,12],[211,5,211,6],[211,7,211,12],[211,0,212,4]]}
["TRAINING INVOICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
["DIRECT LABOR (DL) AND FRINGE BENEFITS (FB)"]
[" Hourly (Unloaded)"]
["Employee Name","Job Classification","DIRECT LABOR:\n\nActual\nDirect Labor Rate\nBilled/Match\n($ per hour)","FRINGE BENEFITS:\n\nActual\nFringe Benefit Rate\nBilled/Match (%)","DIRECT LABOR:\n\nActual\n# of Hours Billed/Match This Period","DIRECT LABOR:\n\nActual\nDL Rate x Hours \n(also FB Base amount)","FRINGE BENEFITS:\n\nActual\nFB Rate x Base amount","DIRECT LABOR:\n\nActual\nCEC Reimbursable DL Expenses","DIRECT LABOR:\n\nActual Match \nShare DL\nExpenses","FRINGE BENEFITS:\n\nActual\nCEC Reimbursable FB Expenses","FRINGE BENEFITS:\n\nActual\nMatch Share FB Expenses","DIRECT LABOR:\n\nDL Total","FRINGE BENEFITS:\n\nFB Total"]
["First Name Last Name1","Project Manager1",43.86,0.51200000000000001,10,{"$f":"ROUND($C5*$E5,2)","v":438.6},{"$f":"ROUND(D5*F5,2)","v":224.56},{"$f":"438.6+0.004999999","v":438.60499999900003},0,{"$f":"224.56+0.0049","v":224.56489999999999},0,{"$f":"SUM(ROUND(H5:I5,2))","v":438.6},{"$f":"SUM(ROUND(J5:K5,2))","v":224.56}]
["First Name Last Name2","Project Manager2",68.91,0.624,10,{"$f":"ROUND($C6*$E6,2)","v":689.1},{"$f":"ROUND(D6*F6,2)","v":430},689.1,0,{"$f":"430+0","v":430},0,{"$f":"SUM(ROUND(H6:I6,2))","v":689.1},{"$f":"SUM(ROUND(J6:K6,2))","v":430}]
["First Name Last Name3","Project Manager3",85.26,0.73299999999999998,10,852.6,624.96,852.6,0,{"$f":"624.96+0","v":624.96},0,{"$f":"SUM(ROUND(H7:I7,2))","v":852.6},{"$f":"SUM(ROUND(J7:K7,2))","v":624.96}]
["First Name Last Name4","Engineer1",28.53,0.46600000000000003,20,570.6,265.89999999999998,570.6,0,{"$f":"265.9+0","v":265.89999999999998},0,{"$f":"SUM(ROUND(H8:I8,2))","v":570.6},{"$f":"SUM(ROUND(J8:K8,2))","v":265.89999999999998}]
["First Name Last Name5","Engineer2",41.25,0.49299999999999999,20,825,406.73,825,0,{"$f":"406.73+0","v":406.73},0,{"$f":"SUM(ROUND(H9:I9,2))","v":825},{"$f":"SUM(ROUND(J9:K9,2))","v":406.73}]
["First Name Last Name6","Engineer3",79.849999999999994,0.53700000000000003,20,1597,{"$f":"ROUND(D10*F10,2)","v":857.59},1597,0,{"$f":"857.59+0.01","v":857.6},0,{"$f":"SUM(ROUND(H10:I10,2))","v":1597},{"$f":"SUM(ROUND(J10:K10,2))","v":857.6}]
[null,null,0,0,0,0,{"$f":"ROUND(D11*F11,2)","v":0},0,0,0,0,{"$f":"SUM(ROUND(H11:I11,2))","v":0},{"$f":"SUM(ROUND(J11:K11,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H12:I12,2))","v":0},{"$f":"SUM(ROUND(J12:K12,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H13:I13,2))","v":0},{"$f":"SUM(ROUND(J13:K13,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H14:I14,2))","v":0},{"$f":"SUM(ROUND(J14:K14,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H15:I15,2))","v":0},{"$f":"SUM(ROUND(J15:K15,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H16:I16,2))","v":0},{"$f":"SUM(ROUND(J16:K16,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H17:I17,2))","v":0},{"$f":"SUM(ROUND(J17:K17,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H18:I18,2))","v":0},{"$f":"SUM(ROUND(J18:K18,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H19:I19,2))","v":0},{"$f":"SUM(ROUND(J19:K19,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H20:I20,2))","v":0},{"$f":"SUM(ROUND(J20:K20,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H21:I21,2))","v":0},{"$f":"SUM(ROUND(J21:K21,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H22:I22,2))","v":0},{"$f":"SUM(ROUND(J22:K22,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H23:I23,2))","v":0},{"$f":"SUM(ROUND(J23:K23,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H24:I24,2))","v":0},{"$f":"SUM(ROUND(J24:K24,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H25:I25,2))","v":0},{"$f":"SUM(ROUND(J25:K25,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H26:I26,2))","v":0},{"$f":"SUM(ROUND(J26:K26,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H27:I27,2))","v":0},{"$f":"SUM(ROUND(J27:K27,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H28:I28,2))","v":0},{"$f":"SUM(ROUND(J28:K28,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H29:I29,2))","v":0},{"$f":"SUM(ROUND(J29:K29,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H30:I30,2))","v":0},{"$f":"SUM(ROUND(J30:K30,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H31:I31,2))","v":0},{"$f":"SUM(ROUND(J31:K31,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H32:I32,2))","v":0},{"$f":"SUM(ROUND(J32:K32,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H33:I33,2))","v":0},{"$f":"SUM(ROUND(J33:K33,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H34:I34,2))","v":0},{"$f":"SUM(ROUND(J34:K34,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H35:I35,2))","v":0},{"$f":"SUM(ROUND(J35:K35,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H36:I36,2))","v":0},{"$f":"SUM(ROUND(J36:K36,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H37:I37,2))","v":0},{"$f":"SUM(ROUND(J37:K37,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H38:I38,2))","v":0},{"$f":"SUM(ROUND(J38:K38,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H39:I39,2))","v":0},{"$f":"SUM(ROUND(J39:K39,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H40:I40,2))","v":0},{"$f":"SUM(ROUND(J40:K40,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H41:I41,2))","v":0},{"$f":"SUM(ROUND(J41:K41,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H42:I42,2))","v":0},{"$f":"SUM(ROUND(J42:K42,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H43:I43,2))","v":0},{"$f":"SUM(ROUND(J43:K43,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H44:I44,2))","v":0},{"$f":"SUM(ROUND(J44:K44,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H45:I45,2))","v":0},{"$f":"SUM(ROUND(J45:K45,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H46:I46,2))","v":0},{"$f":"SUM(ROUND(J46:K46,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H47:I47,2))","v":0},{"$f":"SUM(ROUND(J47:K47,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H48:I48,2))","v":0},{"$f":"SUM(ROUND(J48:K48,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H49:I49,2))","v":0},{"$f":"SUM(ROUND(J49:K49,2))","v":0}]
[null,null,0,0,0,0,{"$f":"ROUND(D50*F50,2)","v":0},0,0,0,0,{"$f":"SUM(ROUND(H50:I50,2))","v":0},{"$f":"SUM(ROUND(J50:K50,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H51:I51,2))","v":0},{"$f":"SUM(ROUND(J51:K51,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H52:I52,2))","v":0},{"$f":"SUM(ROUND(J52:K52,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H53:I53,2))","v":0},{"$f":"SUM(ROUND(J53:K53,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H54:I54,2))","v":0},{"$f":"SUM(ROUND(J54:K54,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H55:I55,2))","v":0},{"$f":"SUM(ROUND(J55:K55,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H56:I56,2))","v":0},{"$f":"SUM(ROUND(J56:K56,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H57:I57,2))","v":0},{"$f":"SUM(ROUND(J57:K57,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H58:I58,2))","v":0},{"$f":"SUM(ROUND(J58:K58,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H59:I59,2))","v":0},{"$f":"SUM(ROUND(J59:K59,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H60:I60,2))","v":0},{"$f":"SUM(ROUND(J60:K60,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H61:I61,2))","v":0},{"$f":"SUM(ROUND(J61:K61,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H62:I62,2))","v":0},{"$f":"SUM(ROUND(J62:K62,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H63:I63,2))","v":0},{"$f":"SUM(ROUND(J63:K63,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H64:I64,2))","v":0},{"$f":"SUM(ROUND(J64:K64,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H65:I65,2))","v":0},{"$f":"SUM(ROUND(J65:K65,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H66:I66,2))","v":0},{"$f":"SUM(ROUND(J66:K66,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H67:I67,2))","v":0},{"$f":"SUM(ROUND(J67:K67,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H68:I68,2))","v":0},{"$f":"SUM(ROUND(J68:K68,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H69:I69,2))","v":0},{"$f":"SUM(ROUND(J69:K69,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H70:I70,2))","v":0},{"$f":"SUM(ROUND(J70:K70,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H71:I71,2))","v":0},{"$f":"SUM(ROUND(J71:K71,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H72:I72,2))","v":0},{"$f":"SUM(ROUND(J72:K72,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H73:I73,2))","v":0},{"$f":"SUM(ROUND(J73:K73,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H74:I74,2))","v":0},{"$f":"SUM(ROUND(J74:K74,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H75:I75,2))","v":0},{"$f":"SUM(ROUND(J75:K75,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H76:I76,2))","v":0},{"$f":"SUM(ROUND(J76:K76,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H77:I77,2))","v":0},{"$f":"SUM(ROUND(J77:K77,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H78:I78,2))","v":0},{"$f":"SUM(ROUND(J78:K78,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H79:I79,2))","v":0},{"$f":"SUM(ROUND(J79:K79,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H80:I80,2))","v":0},{"$f":"SUM(ROUND(J80:K80,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H81:I81,2))","v":0},{"$f":"SUM(ROUND(J81:K81,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H82:I82,2))","v":0},{"$f":"SUM(ROUND(J82:K82,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H83:I83,2))","v":0},{"$f":"SUM(ROUND(J83:K83,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H84:I84,2))","v":0},{"$f":"SUM(ROUND(J84:K84,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H85:I85,2))","v":0},{"$f":"SUM(ROUND(J85:K85,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H86:I86,2))","v":0},{"$f":"SUM(ROUND(J86:K86,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H87:I87,2))","v":0},{"$f":"SUM(ROUND(J87:K87,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H88:I88,2))","v":0},{"$f":"SUM(ROUND(J88:K88,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H89:I89,2))","v":0},{"$f":"SUM(ROUND(J89:K89,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H90:I90,2))","v":0},{"$f":"SUM(ROUND(J90:K90,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H91:I91,2))","v":0},{"$f":"SUM(ROUND(J91:K91,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H92:I92,2))","v":0},{"$f":"SUM(ROUND(J92:K92,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H93:I93,2))","v":0},{"$f":"SUM(ROUND(J93:K93,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H94:I94,2))","v":0},{"$f":"SUM(ROUND(J94:K94,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H95:I95,2))","v":0},{"$f":"SUM(ROUND(J95:K95,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H96:I96,2))","v":0},{"$f":"SUM(ROUND(J96:K96,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H97:I97,2))","v":0},{"$f":"SUM(ROUND(J97:K97,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H98:I98,2))","v":0},{"$f":"SUM(ROUND(J98:K98,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H99:I99,2))","v":0},{"$f":"SUM(ROUND(J99:K99,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H100:I100,2))","v":0},{"$f":"SUM(ROUND(J100:K100,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H101:I101,2))","v":0},{"$f":"SUM(ROUND(J101:K101,2))","v":0}]
[null,null,0,0,0,0,{"$f":"ROUND(D102*F102,2)","v":0},0,0,0,0,{"$f":"SUM(ROUND(H102:I102,2))","v":0},{"$f":"SUM(ROUND(J102:K102,2))","v":0}]
["CEC USE ONLY",null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H103:I103,2))","v":0},{"$f":"SUM(ROUND(J103:K103,2))","v":0}]
["CEC USE ONLY",null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H104:I104,2))","v":0},{"$f":"SUM(ROUND(J104:K104,2))","v":0}]
["Hourly Totals",null,null,null,null,{"$f":"SUM(F5:F104)","v":4972.8999999999996},2809.7400000000002,{"$f":"SUM(ROUND(H5:H104,2))","v":4972.8999999999996},{"$f":"SUM(ROUND(I5:I104,2))","v":0},{"$f":"SUM(ROUND(J5:J104,2))","v":2809.75},{"$f":"SUM(ROUND(K5:K104,2))","v":0},4972.8999999999996,2809.75]
[]
["Salaried (Unloaded)"]
["Employee Name","Job Classification","DIRECT LABOR:\n\nActual Direct Labor Rate\nBilled/Match\n($ per mo./yr.)\n","FRINGE BENEFITS:\n\nActual Fringe Benefit Rate\nBilled/Match (%)","DIRECT LABOR:\n\nActual # of Months Billed/Match This Period","DIRECT \nLABOR:\n\nActual Rate x Months (also FB Base amount)","FRINGE BENEFITS:\n\nActual FB Rate x Base amount","DIRECT \nLABOR:\n\nActual\nCEC Reimbursable DL Expenses","DIRECT \nLABOR:\n\nActual Match \nShare DL\nExpenses","FRINGE BENEFITS:\n\nActual\nCEC Reimbursable FB Expenses","FRINGE BENEFITS:\n\nActual Match \nShare FB\nExpenses","DIRECT \nLABOR:\n\nDL Total","FRINGE BENEFITS:\n\nFB Total"]
["First Name Last Name 1","Engineer 4",8000,0.3,1,{"$f":"ROUND($C109*$E109,2)","v":8000},{"$f":"ROUND(D109*F109,2)","v":2400},6000,2000,{"$f":"1800+0.01","v":1800.01},600,{"$f":"SUM(ROUND(H109:I109,2))","v":8000},{"$f":"SUM(ROUND(J109:K109,2))","v":2400.0100000000002}]
[null,null,0,0,0,{"$f":"ROUND($C110*$E110,2)","v":0},{"$f":"ROUND(D110*F110,2)","v":0},0,0,0,0,{"$f":"SUM(ROUND(H110:I110,2))","v":0},{"$f":"SUM(ROUND(J110:K110,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H111:I111,2))","v":0},{"$f":"SUM(ROUND(J111:K111,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H112:I112,2))","v":0},{"$f":"SUM(ROUND(J112:K112,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H113:I113,2))","v":0},{"$f":"SUM(ROUND(J113:K113,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H114:I114,2))","v":0},{"$f":"SUM(ROUND(J114:K114,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H115:I115,2))","v":0},{"$f":"SUM(ROUND(J115:K115,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H116:I116,2))","v":0},{"$f":"SUM(ROUND(J116:K116,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H117:I117,2))","v":0},{"$f":"SUM(ROUND(J117:K117,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H118:I118,2))","v":0},{"$f":"SUM(ROUND(J118:K118,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H119:I119,2))","v":0},{"$f":"SUM(ROUND(J119:K119,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H120:I120,2))","v":0},{"$f":"SUM(ROUND(J120:K120,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H121:I121,2))","v":0},{"$f":"SUM(ROUND(J121:K121,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H122:I122,2))","v":0},{"$f":"SUM(ROUND(J122:K122,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H123:I123,2))","v":0},{"$f":"SUM(ROUND(J123:K123,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H124:I124,2))","v":0},{"$f":"SUM(ROUND(J124:K124,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H125:I125,2))","v":0},{"$f":"SUM(ROUND(J125:K125,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H126:I126,2))","v":0},{"$f":"SUM(ROUND(J126:K126,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H127:I127,2))","v":0},{"$f":"SUM(ROUND(J127:K127,2))","v":0}]
[null,null,0,0,0,0,{"$f":"ROUND(D128*F128,2)","v":0},0,0,0,0,{"$f":"SUM(ROUND(H128:I128,2))","v":0},{"$f":"SUM(ROUND(J128:K128,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H129:I129,2))","v":0},{"$f":"SUM(ROUND(J129:K129,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H130:I130,2))","v":0},{"$f":"SUM(ROUND(J130:K130,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H131:I131,2))","v":0},{"$f":"SUM(ROUND(J131:K131,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H132:I132,2))","v":0},{"$f":"SUM(ROUND(J132:K132,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H133:I133,2))","v":0},{"$f":"SUM(ROUND(J133:K133,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H134:I134,2))","v":0},{"$f":"SUM(ROUND(J134:K134,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H135:I135,2))","v":0},{"$f":"SUM(ROUND(J135:K135,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H136:I136,2))","v":0},{"$f":"SUM(ROUND(J136:K136,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H137:I137,2))","v":0},{"$f":"SUM(ROUND(J137:K137,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H138:I138,2))","v":0},{"$f":"SUM(ROUND(J138:K138,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H139:I139,2))","v":0},{"$f":"SUM(ROUND(J139:K139,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H140:I140,2))","v":0},{"$f":"SUM(ROUND(J140:K140,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H141:I141,2))","v":0},{"$f":"SUM(ROUND(J141:K141,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H142:I142,2))","v":0},{"$f":"SUM(ROUND(J142:K142,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H143:I143,2))","v":0},{"$f":"SUM(ROUND(J143:K143,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H144:I144,2))","v":0},{"$f":"SUM(ROUND(J144:K144,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H145:I145,2))","v":0},{"$f":"SUM(ROUND(J145:K145,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H146:I146,2))","v":0},{"$f":"SUM(ROUND(J146:K146,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H147:I147,2))","v":0},{"$f":"SUM(ROUND(J147:K147,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H148:I148,2))","v":0},{"$f":"SUM(ROUND(J148:K148,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H149:I149,2))","v":0},{"$f":"SUM(ROUND(J149:K149,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H150:I150,2))","v":0},{"$f":"SUM(ROUND(J150:K150,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H151:I151,2))","v":0},{"$f":"SUM(ROUND(J151:K151,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H152:I152,2))","v":0},{"$f":"SUM(ROUND(J152:K152,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H153:I153,2))","v":0},{"$f":"SUM(ROUND(J153:K153,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H154:I154,2))","v":0},{"$f":"SUM(ROUND(J154:K154,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H155:I155,2))","v":0},{"$f":"SUM(ROUND(J155:K155,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H156:I156,2))","v":0},{"$f":"SUM(ROUND(J156:K156,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H157:I157,2))","v":0},{"$f":"SUM(ROUND(J157:K157,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H158:I158,2))","v":0},{"$f":"SUM(ROUND(J158:K158,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H159:I159,2))","v":0},{"$f":"SUM(ROUND(J159:K159,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H160:I160,2))","v":0},{"$f":"SUM(ROUND(J160:K160,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H161:I161,2))","v":0},{"$f":"SUM(ROUND(J161:K161,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H162:I162,2))","v":0},{"$f":"SUM(ROUND(J162:K162,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H163:I163,2))","v":0},{"$f":"SUM(ROUND(J163:K163,2))","v":0}]
[null,null,0,0,0,0,{"$f":"ROUND(D164*F164,2)","v":0},0,0,0,0,{"$f":"SUM(ROUND(H164:I164,2))","v":0},{"$f":"SUM(ROUND(J164:K164,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H165:I165,2))","v":0},{"$f":"SUM(ROUND(J165:K165,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H166:I166,2))","v":0},{"$f":"SUM(ROUND(J166:K166,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H167:I167,2))","v":0},{"$f":"SUM(ROUND(J167:K167,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H168:I168,2))","v":0},{"$f":"SUM(ROUND(J168:K168,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H169:I169,2))","v":0},{"$f":"SUM(ROUND(J169:K169,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H170:I170,2))","v":0},{"$f":"SUM(ROUND(J170:K170,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H171:I171,2))","v":0},{"$f":"SUM(ROUND(J171:K171,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H172:I172,2))","v":0},{"$f":"SUM(ROUND(J172:K172,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H173:I173,2))","v":0},{"$f":"SUM(ROUND(J173:K173,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H174:I174,2))","v":0},{"$f":"SUM(ROUND(J174:K174,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H175:I175,2))","v":0},{"$f":"SUM(ROUND(J175:K175,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H176:I176,2))","v":0},{"$f":"SUM(ROUND(J176:K176,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H177:I177,2))","v":0},{"$f":"SUM(ROUND(J177:K177,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H178:I178,2))","v":0},{"$f":"SUM(ROUND(J178:K178,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H179:I179,2))","v":0},{"$f":"SUM(ROUND(J179:K179,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H180:I180,2))","v":0},{"$f":"SUM(ROUND(J180:K180,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H181:I181,2))","v":0},{"$f":"SUM(ROUND(J181:K181,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H182:I182,2))","v":0},{"$f":"SUM(ROUND(J182:K182,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H183:I183,2))","v":0},{"$f":"SUM(ROUND(J183:K183,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H184:I184,2))","v":0},{"$f":"SUM(ROUND(J184:K184,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H185:I185,2))","v":0},{"$f":"SUM(ROUND(J185:K185,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H186:I186,2))","v":0},{"$f":"SUM(ROUND(J186:K186,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H187:I187,2))","v":0},{"$f":"SUM(ROUND(J187:K187,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H188:I188,2))","v":0},{"$f":"SUM(ROUND(J188:K188,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H189:I189,2))","v":0},{"$f":"SUM(ROUND(J189:K189,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H190:I190,2))","v":0},{"$f":"SUM(ROUND(J190:K190,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H191:I191,2))","v":0},{"$f":"SUM(ROUND(J191:K191,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H192:I192,2))","v":0},{"$f":"SUM(ROUND(J192:K192,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H193:I193,2))","v":0},{"$f":"SUM(ROUND(J193:K193,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H194:I194,2))","v":0},{"$f":"SUM(ROUND(J194:K194,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H195:I195,2))","v":0},{"$f":"SUM(ROUND(J195:K195,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H196:I196,2))","v":0},{"$f":"SUM(ROUND(J196:K196,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H197:I197,2))","v":0},{"$f":"SUM(ROUND(J197:K197,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H198:I198,2))","v":0},{"$f":"SUM(ROUND(J198:K198,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H199:I199,2))","v":0},{"$f":"SUM(ROUND(J199:K199,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H200:I200,2))","v":0},{"$f":"SUM(ROUND(J200:K200,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H201:I201,2))","v":0},{"$f":"SUM(ROUND(J201:K201,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H202:I202,2))","v":0},{"$f":"SUM(ROUND(J202:K202,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H203:I203,2))","v":0},{"$f":"SUM(ROUND(J203:K203,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H204:I204,2))","v":0},{"$f":"SUM(ROUND(J204:K204,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H205:I205,2))","v":0},{"$f":"SUM(ROUND(J205:K205,2))","v":0}]
[null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H206:I206,2))","v":0},{"$f":"SUM(ROUND(J206:K206,2))","v":0}]
["CEC USE ONLY",null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(ROUND(H207:I207,2))","v":0},{"$f":"SUM(ROUND(J207:K207,2))","v":0}]
["CEC USE ONLY",null,0,0,0,0,{"$f":"ROUND(D208*F208,2)","v":0},0,0,0,0,{"$f":"SUM(ROUND(H208:I208,2))","v":0},{"$f":"SUM(ROUND(J208:K208,2))","v":0}]
["Monthly Totals",null,null,null,null,{"$f":"SUM(F109:F208)","v":8000},2400,{"$f":"SUM(ROUND(H109:H208,2))","v":6000},{"$f":"SUM(ROUND(I109:I208,2))","v":2000},{"$f":"SUM(ROUND(J109:J208,2))","v":1800.01},{"$f":"SUM(ROUND(K109:K208,2))","v":600},8000,2400.0100000000002]
[]
["Direct Labor and Fringe Benefits Grand Totals"]
[null,null,null,null,null,"Rate x Quantity (Calc. Check)",null,"Actuals"]
[null,null,null,null,null,"DL Total","FB Total","DL Reimbursable","DL Match Share","FB Reimbursable","FB Match Share","DL Total","FB Total"]
["Grand Totals",null,null,null,null,{"$f":"F105+F209","v":12972.9},5209.74,10972.9,2000,4609.76,600,12972.9,5209.76]
[]
["Worksheet Specific Instructions"]
["CONDITIONAL FORMATTING APPLIED:  If an Actual CEC Reimbursable Fringe Benefit Expense is greater than the Actual CEC Reimbursable DL Expense multiplied by the Actual Fringe Benefit Rate (%), as indicated by red conditional formatting, then the invoice will have to be corrected and the Recipient notified that the CEC does not pay for Fringe Benefits on Direct Labor charged as a Match Share expense."]

{"sheet":"Travel","index":4,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,0,1,8],[0,0,0,8],[53,0,53,5]]}
["TRAINING INVOICE",null,null,null,null,null,null,null,null,null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
["TRAVEL"]
["Budget Worksheet Reference ID","Task #","Traveler Name and Job  Classification","Dates of Travel (From/To)","Departure and Destination","Trip Purpose","Billed\nCEC\nExpenses","Match \nShare\nExpenses","Total"]
["T-1",1,"First Name Last Name, job classification","3/20/20 - 3/23/20","Sacramento to LA","Sacramento to LA; CPR#1 and Site Visit #1",78.63,21.56,{"$f":"SUM(ROUND(G4:H4,2))","v":100.19}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G5:H5,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G6:H6,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G7:H7,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G8:H8,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G9:H9,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G10:H10,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G11:H11,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G12:H12,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G13:H13,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G14:H14,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G15:H15,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G16:H16,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G17:H17,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G18:H18,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G19:H19,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G20:H20,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G21:H21,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G22:H22,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G23:H23,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G24:H24,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G25:H25,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G26:H26,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G27:H27,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G28:H28,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G29:H29,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G30:H30,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G31:H31,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G32:H32,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G33:H33,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G34:H34,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G35:H35,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G36:H36,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G37:H37,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G38:H38,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G39:H39,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G40:H40,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G41:H41,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G42:H42,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G43:H43,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G44:H44,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G45:H45,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G46:H46,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G47:H47,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G48:H48,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G49:H49,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G50:H50,2))","v":0}]
[null,null,null,null,null,null,0,0,{"$f":"SUM(ROUND(G51:H51,2))","v":0}]
[null,null,"CEC USE ONLY",null,null,null,0,0,{"$f":"SUM(ROUND(G52:H52,2))","v":0}]
[null,null,"CEC USE ONLY",null,null,null,0,0,{"$f":"SUM(ROUND(G53:H53,2))","v":0}]
["Grand Totals",null,null,null,null,null,{"$f":"SUM(ROUND(G4:G53,2))","v":78.63},{"$f":"SUM(ROUND(H4:H53,2))","v":21.56},{"$f":"SUM(I4:I53)","v":100.19}]

{"sheet":"Equipment","index":5,"n_rows":211,"n_cols":18,"rows_kept":211,"cut":false,"hidden":false,"merged":[[206,11,206,12],[2,2,3,2],[2,4,3,4],[1,0,1,12],[0,0,0,12],[209,0,209,12],[210,0,210,12],[2,11,2,12],[2,0,3,0],[2,1,3,1],[2,3,3,3],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[206,0,206,6],[208,0,208,12]]}
["TRAINING INVOICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
["EQUIPMENT"]
["Budget Worksheet Reference ID","Task #","Legal Name of entity providing equipment: Recipient/ Subrecipient/ Vendor","Description","Purpose","# of Units\nBilled/Match","Unit Cost\nBilled/Match \nThis Period ($)","Total:  \n# of Units x Unit Cost","Billed\nCEC\nExpenses","Match \nShare\nExpenses","Total","Use If Requesting Payment for Incurred Costs or Reimbursement for Partial Payments"]
[null,null,null,null,null,null,null,null,null,null,null,"Check Box if Expense is a Partial Payment","Provide payment amount(s) and CEC invoice number(s) for prior payment(s)"]
["E-1",4,"M&M Inc.","Equipment Type A","Needed to help complete project",5,27697.45,{"$f":"ROUND(F5*G5,2)","v":138487.25},{"$f":"H5-100000-25000","v":13487.25},25000,{"$f":"SUM(ROUND(I5:J5,2))","v":38487.25},null,"$100,000 on invoice 9"]
["E-2",2,"Equipment Inc.","Equipment Type B","Needed to help complete project",11,48239.11,{"$f":"ROUND(F6*G6,2)","v":530630.21},{"$f":"530630.21-21563.57","v":509066.63999999996},21563.57,{"$f":"SUM(ROUND(I6:J6,2))","v":530630.21}]
["E-3",2,"Equipment Inc.","Equipment Type C","Needed to help complete project",3,4963,14889,7000,{"$f":"H7-7000","v":7889},{"$f":"SUM(ROUND(I7:J7,2))","v":14889}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I8:J8,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I9:J9,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I10:J10,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I11:J11,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I12:J12,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I13:J13,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I14:J14,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I15:J15,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I16:J16,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I17:J17,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I18:J18,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I19:J19,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I20:J20,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I21:J21,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I22:J22,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I23:J23,2))","v":0}]
[null,null,null,null,null,0,0,{"$f":"ROUND(F24*G24,2)","v":0},0,0,{"$f":"SUM(ROUND(I24:J24,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I25:J25,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I26:J26,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I27:J27,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I28:J28,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I29:J29,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I30:J30,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I31:J31,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I32:J32,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I33:J33,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I34:J34,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I35:J35,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I36:J36,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I37:J37,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I38:J38,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I39:J39,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I40:J40,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I41:J41,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I42:J42,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I43:J43,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I44:J44,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I45:J45,2))","v":0}]
[null,null,null,null,null,0,0,{"$f":"ROUND(F46*G46,2)","v":0},0,0,{"$f":"SUM(ROUND(I46:J46,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I47:J47,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I48:J48,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I49:J49,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I50:J50,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I51:J51,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I52:J52,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I53:J53,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I54:J54,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I55:J55,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I56:J56,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I57:J57,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I58:J58,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I59:J59,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I60:J60,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I61:J61,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I62:J62,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I63:J63,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I64:J64,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I65:J65,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I66:J66,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I67:J67,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I68:J68,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I69:J69,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I70:J70,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I71:J71,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I72:J72,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I73:J73,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I74:J74,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I75:J75,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I76:J76,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I77:J77,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I78:J78,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I79:J79,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I80:J80,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I81:J81,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I82:J82,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I83:J83,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I84:J84,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I85:J85,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I86:J86,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I87:J87,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I88:J88,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I89:J89,2))","v":0}]
[null,null,null,null,null,0,0,{"$f":"ROUND(F90*G90,2)","v":0},0,0,{"$f":"SUM(ROUND(I90:J90,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I91:J91,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I92:J92,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I93:J93,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I94:J94,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I95:J95,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I96:J96,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I97:J97,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I98:J98,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I99:J99,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I100:J100,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I101:J101,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I102:J102,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I103:J103,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I104:J104,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I105:J105,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I106:J106,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I107:J107,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I108:J108,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I109:J109,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I110:J110,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I111:J111,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I112:J112,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I113:J113,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I114:J114,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I115:J115,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I116:J116,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I117:J117,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I118:J118,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I119:J119,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I120:J120,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I121:J121,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I122:J122,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I123:J123,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I124:J124,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I125:J125,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I126:J126,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I127:J127,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I128:J128,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I129:J129,2))","v":0}]
[null,null,null,null,null,0,0,{"$f":"ROUND(F130*G130,2)","v":0},0,0,{"$f":"SUM(ROUND(I130:J130,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I131:J131,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I132:J132,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I133:J133,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I134:J134,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I135:J135,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I136:J136,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I137:J137,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I138:J138,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I139:J139,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I140:J140,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I141:J141,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I142:J142,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I143:J143,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I144:J144,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I145:J145,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I146:J146,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I147:J147,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I148:J148,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I149:J149,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I150:J150,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I151:J151,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I152:J152,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I153:J153,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I154:J154,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I155:J155,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I156:J156,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I157:J157,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I158:J158,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I159:J159,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I160:J160,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I161:J161,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I162:J162,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I163:J163,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I164:J164,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I165:J165,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I166:J166,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I167:J167,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I168:J168,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I169:J169,2))","v":0}]
[null,null,null,null,null,0,0,{"$f":"ROUND(F170*G170,2)","v":0},0,0,{"$f":"SUM(ROUND(I170:J170,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I171:J171,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I172:J172,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I173:J173,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I174:J174,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I175:J175,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I176:J176,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I177:J177,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I178:J178,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I179:J179,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I180:J180,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I181:J181,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I182:J182,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I183:J183,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I184:J184,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I185:J185,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I186:J186,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I187:J187,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I188:J188,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I189:J189,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I190:J190,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I191:J191,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I192:J192,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I193:J193,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I194:J194,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I195:J195,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I196:J196,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I197:J197,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I198:J198,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I199:J199,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I200:J200,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I201:J201,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I202:J202,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I203:J203,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I204:J204,2))","v":0}]
[null,null,"CEC USE ONLY",null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I205:J205,2))","v":0}]
[null,null,"CEC USE ONLY",null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I206:J206,2))","v":0}]
["Grand Totals",null,null,null,null,null,null,{"$f":"SUM(H5:H206)","v":684006.46},{"$f":"SUM(ROUND(I5:I206,2))","v":529553.89},{"$f":"SUM(ROUND(J5:J206,2))","v":54452.57},{"$f":"SUM(K5:K206)","v":584006.46}]
[]
["Worksheet Specific Instructions"]
["CONDITIONAL FORMATTING APPLIED:  If invoice includes reimbursement for equipment with an incurred total line item cost of $100K or more (amount includes both CEC Share and Match Share expenses), as indicated by yellow background conditional formatting, Recipient must provide proof of payment before the next invoice can be paid."]
["CONDITIONAL FORMATTING APPLIED:  If invoice includes: 1) equipment with a per line item incurred cost of $500K or greater; or 2) a single equipment vendor with $500K or more in equipment incurred costs (CAM might have to check manually if expenses are spread over more than one line item), as indicated by red background conditional formatting, CAM to contact vendor to independently verify equipment purchase. Amount includes both CEC Share and Match Share expenses."]

{"sheet":"Materials & Miscellaneous","index":6,"n_rows":210,"n_cols":18,"rows_kept":210,"cut":false,"hidden":false,"merged":[[208,0,208,12],[2,7,3,7],[206,0,206,6],[0,0,0,12],[1,0,1,12],[209,0,209,12],[2,11,2,12],[2,10,3,10],[2,9,3,9],[2,8,3,8],[2,4,3,4],[2,3,3,3],[2,1,3,1],[2,0,3,0],[2,2,3,2],[2,5,3,5],[2,6,3,6]]}
["TRAINING INVOICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
["MATERIALS & MISCELLANEOUS"]
["Budget Worksheet Reference ID","Task #","Legal Name of entity providing the item(s): Recipient/ Subrecipient/ Vendor","Description","Purpose","# of Units\nBilled/ Match","Unit Cost\nBilled/Match \nThis Period ($)","Total:  \n# of Units x Unit Cost","Billed\nCEC Expenses","Match \nShare\nExpenses","Total","Use If Requesting Payment for Incurred Costs or Reimbursement for Partial Payments"]
[null,null,null,null,null,null,null,null,null,null,null,"Check Box if Expense is a Partial Payment","Provide payment amount(s) and CEC invoice number(s) for prior payment(s)"]
["M-1",1,"Materials LLC","Material Type Z","to build item for project",50,149.53,{"$f":"ROUND(F5*G5,2)","v":7476.5},5267.23,{"$f":"H5-I5","v":2209.2700000000004},{"$f":"SUM(ROUND(I5:J5,2))","v":7476.5}]
["M-2","2","M2G Inc.","Material Type","to lay foundation for equipment",1,29346.17,{"$f":"ROUND(F6*G6,2)","v":29346.17},24391.39,{"$f":"H6-I6","v":4954.7799999999988},{"$f":"SUM(ROUND(I6:J6,2))","v":29346.17}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I7:J7,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I8:J8,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I9:J9,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I10:J10,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I11:J11,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I12:J12,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I13:J13,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I14:J14,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I15:J15,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I16:J16,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I17:J17,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I18:J18,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I19:J19,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I20:J20,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I21:J21,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I22:J22,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I23:J23,2))","v":0}]
[null,null,null,null,null,0,0,{"$f":"ROUND(F24*G24,2)","v":0},0,0,{"$f":"SUM(ROUND(I24:J24,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I25:J25,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I26:J26,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I27:J27,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I28:J28,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I29:J29,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I30:J30,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I31:J31,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I32:J32,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I33:J33,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I34:J34,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I35:J35,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I36:J36,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I37:J37,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I38:J38,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I39:J39,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I40:J40,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I41:J41,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I42:J42,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I43:J43,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I44:J44,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I45:J45,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I46:J46,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I47:J47,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I48:J48,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I49:J49,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I50:J50,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I51:J51,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I52:J52,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I53:J53,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I54:J54,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I55:J55,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I56:J56,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I57:J57,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I58:J58,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I59:J59,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I60:J60,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I61:J61,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I62:J62,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I63:J63,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I64:J64,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I65:J65,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I66:J66,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I67:J67,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I68:J68,2))","v":0}]
[null,null,null,null,null,0,0,{"$f":"ROUND(F69*G69,2)","v":0},0,0,{"$f":"SUM(ROUND(I69:J69,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I70:J70,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I71:J71,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I72:J72,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I73:J73,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I74:J74,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I75:J75,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I76:J76,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I77:J77,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I78:J78,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I79:J79,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I80:J80,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I81:J81,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I82:J82,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I83:J83,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I84:J84,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I85:J85,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I86:J86,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I87:J87,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I88:J88,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I89:J89,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I90:J90,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I91:J91,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I92:J92,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I93:J93,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I94:J94,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I95:J95,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I96:J96,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I97:J97,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I98:J98,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I99:J99,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I100:J100,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I101:J101,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I102:J102,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I103:J103,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I104:J104,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I105:J105,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I106:J106,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I107:J107,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I108:J108,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I109:J109,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I110:J110,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I111:J111,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I112:J112,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I113:J113,2))","v":0}]
[null,null,null,null,null,0,0,{"$f":"ROUND(F114*G114,2)","v":0},0,0,{"$f":"SUM(ROUND(I114:J114,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I115:J115,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I116:J116,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I117:J117,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I118:J118,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I119:J119,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I120:J120,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I121:J121,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I122:J122,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I123:J123,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I124:J124,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I125:J125,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I126:J126,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I127:J127,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I128:J128,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I129:J129,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I130:J130,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I131:J131,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I132:J132,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I133:J133,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I134:J134,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I135:J135,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I136:J136,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I137:J137,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I138:J138,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I139:J139,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I140:J140,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I141:J141,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I142:J142,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I143:J143,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I144:J144,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I145:J145,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I146:J146,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I147:J147,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I148:J148,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I149:J149,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I150:J150,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I151:J151,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I152:J152,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I153:J153,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I154:J154,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I155:J155,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I156:J156,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I157:J157,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I158:J158,2))","v":0}]
[null,null,null,null,null,0,0,{"$f":"ROUND(F159*G159,2)","v":0},0,0,{"$f":"SUM(ROUND(I159:J159,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I160:J160,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I161:J161,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I162:J162,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I163:J163,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I164:J164,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I165:J165,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I166:J166,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I167:J167,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I168:J168,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I169:J169,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I170:J170,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I171:J171,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I172:J172,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I173:J173,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I174:J174,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I175:J175,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I176:J176,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I177:J177,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I178:J178,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I179:J179,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I180:J180,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I181:J181,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I182:J182,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I183:J183,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I184:J184,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I185:J185,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I186:J186,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I187:J187,2))","v":0}]
[null,null,null,null,null,0,0,{"$f":"ROUND(F188*G188,2)","v":0},0,0,{"$f":"SUM(ROUND(I188:J188,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I189:J189,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I190:J190,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I191:J191,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I192:J192,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I193:J193,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I194:J194,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I195:J195,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I196:J196,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I197:J197,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I198:J198,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I199:J199,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I200:J200,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I201:J201,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I202:J202,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I203:J203,2))","v":0}]
[null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(ROUND(I204:J204,2))","v":0}]
[null,null,"CEC USE ONLY",null,null,0,0,{"$f":"ROUND(F205*G205,2)","v":0},0,0,{"$f":"SUM(ROUND(I205:J205,2))","v":0}]
[null,null,"CEC USE ONLY",null,null,0,0,{"$f":"ROUND(F206*G206,2)","v":0},0,0,{"$f":"SUM(ROUND(I206:J206,2))","v":0}]
["Grand Totals",null,null,null,null,null,null,{"$f":"SUM(H5:H206)","v":36822.67},{"$f":"SUM(ROUND(I5:I206,2))","v":29658.62},{"$f":"SUM(ROUND(J5:J206,2))","v":7164.0499999999993},{"$f":"SUM(K5:K206)","v":36822.67}]
[]
["Worksheet Specific Instructions"]
["CONDITIONAL FORMATTING APPLIED:  Backup documentation (i.e., proof of payment or incurred cost) required for any line item total (not necessarily unit cost) on an invoice that is $5,000 or more (amount includes both CEC Share and Match Share expenses), as indicated by red background conditional formatting."]

{"sheet":"Subs & Vendors","index":7,"n_rows":216,"n_cols":14,"rows_kept":216,"cut":false,"hidden":false,"merged":[[96,7,97,7],[96,8,97,8],[98,7,99,7],[98,8,99,8],[100,7,101,7],[100,8,101,8],[102,7,103,7],[102,8,103,8],[86,7,87,7],[86,8,87,8],[88,7,89,7],[88,8,89,8],[90,7,91,7],[90,8,91,8],[92,7,93,7],[92,8,93,8],[94,7,95,7],[94,8,95,8],[76,7,77,7],[76,8,77,8],[78,7,79,7],[78,8,79,8],[80,7,81,7],[80,8,81,8],[82,7,83,7],[82,8,83,8],[84,7,85,7],[84,8,85,8],[66,7,67,7],[66,8,67,8],[68,7,69,7],[68,8,69,8],[70,7,71,7],[70,8,71,8],[72,7,73,7],[72,8,73,8],[74,7,75,7],[74,8,75,8],[56,7,57,7],[56,8,57,8],[58,7,59,7],[58,8,59,8],[60,7,61,7],[60,8,61,8],[62,7,63,7],[62,8,63,8],[64,7,65,7],[64,8,65,8],[46,7,47,7],[46,8,47,8],[48,7,49,7],[48,8,49,8],[50,7,51,7],[50,8,51,8],[52,7,53,7],[52,8,53,8],[54,7,55,7],[54,8,55,8],[36,7,37,7],[36,8,37,8],[38,7,39,7],[38,8,39,8],[40,7,41,7],[40,8,41,8],[42,7,43,7],[42,8,43,8],[44,7,45,7],[44,8,45,8],[26,8,27,8],[28,7,29,7],[28,8,29,8],[30,7,31,7],[30,8,31,8],[32,7,33,7],[32,8,33,8],[34,7,35,7],[34,8,35,8],[16,8,17,8],[18,7,19,7],[18,8,19,8],[20,7,21,7],[20,8,21,8],[22,7,23,7],[22,8,23,8],[4,7,5,7],[4,8,5,8],[6,7,7,7],[6,8,7,8],[8,7,9,7],[8,8,9,8],[10,7,11,7],[10,8,11,8],[12,7,13,7],[12,8,13,8],[24,7,25,7],[24,8,25,8],[26,7,27,7],[212,0,212,6],[10,0,11,0],[12,0,13,0],[14,0,15,0],[4,1,5,1],[4,0,5,0],[121,0,122,0],[209,0,210,1],[123,0,124,0],[113,0,114,0],[121,1,122,1],[123,1,124,1],[117,1,118,1],[6,0,7,0],[8,0,9,0],[6,1,7,1],[8,1,9,1],[10,1,11,1],[14,7,15,7],[14,8,15,8],[16,7,17,7],[70,0,71,0],[70,1,71,1],[12,1,13,1],[14,1,15,1],[16,0,17,0],[18,0,19,0],[18,1,19,1],[16,1,17,1],[214,0,215,1],[213,0,213,2],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[56,0,57,0],[56,1,57,1],[64,0,65,0],[64,1,65,1],[66,0,67,0],[66,1,67,1],[68,0,69,0],[68,1,69,1],[58,0,59,0],[58,1,59,1],[60,0,61,0],[60,1,61,1],[62,0,63,0],[62,1,63,1],[34,0,35,0],[34,1,35,1],[36,0,37,0],[36,1,37,1],[38,0,39,0],[38,1,39,1],[52,0,53,0],[52,1,53,1],[54,0,55,0],[54,1,55,1],[46,0,47,0],[46,1,47,1],[48,0,49,0],[48,1,49,1],[50,0,51,0],[50,1,51,1],[40,0,41,0],[40,1,41,1],[42,0,43,0],[42,1,43,1],[44,0,45,0],[44,1,45,1],[72,0,73,0],[72,1,73,1],[74,0,75,0],[74,1,75,1],[76,0,77,0],[88,0,89,0],[88,1,89,1],[90,0,91,0],[90,1,91,1],[76,1,77,1],[78,0,79,0],[78,1,79,1],[80,0,81,0],[80,1,81,1],[92,0,93,0],[92,1,93,1],[82,0,83,0],[82,1,83,1],[84,0,85,0],[84,1,85,1],[86,0,87,0],[86,1,87,1],[100,0,101,0],[100,1,101,1],[102,0,103,0],[102,1,103,1],[125,0,126,0],[125,1,126,1],[94,0,95,0],[94,1,95,1],[96,0,97,0],[96,1,97,1],[98,0,99,0],[98,1,99,1],[119,0,120,0],[109,0,110,0],[109,1,110,1],[107,0,107,6],[115,1,116,1],[115,0,116,0],[119,1,120,1],[104,0,105,1],[111,1,112,1],[113,1,114,1],[117,0,118,0],[111,0,112,0],[133,0,134,0],[133,1,134,1],[135,0,136,0],[135,1,136,1],[137,0,138,0],[137,1,138,1],[127,0,128,0],[127,1,128,1],[129,0,130,0],[129,1,130,1],[131,0,132,0],[131,1,132,1],[145,0,146,0],[145,1,146,1],[147,0,148,0],[147,1,148,1],[149,0,150,0],[149,1,150,1],[139,0,140,0],[139,1,140,1],[141,0,142,0],[141,1,142,1],[143,0,144,0],[143,1,144,1],[157,0,158,0],[157,1,158,1],[159,0,160,0],[159,1,160,1],[161,0,162,0],[161,1,162,1],[151,0,152,0],[151,1,152,1],[153,0,154,0],[153,1,154,1],[155,0,156,0],[155,1,156,1],[169,0,170,0],[169,1,170,1],[171,0,172,0],[171,1,172,1],[173,0,174,0],[173,1,174,1],[163,0,164,0],[163,1,164,1],[165,0,166,0],[165,1,166,1],[167,0,168,0],[167,1,168,1],[191,1,192,1],[181,0,182,0],[181,1,182,1],[183,0,184,0],[183,1,184,1],[185,0,186,0],[185,1,186,1],[175,0,176,0],[175,1,176,1],[177,0,178,0],[177,1,178,1],[179,0,180,0],[179,1,180,1],[2,0,2,8],[1,0,1,8],[0,0,0,8],[205,0,206,0],[205,1,206,1],[207,0,208,0],[207,1,208,1],[199,0,200,0],[199,1,200,1],[201,0,202,0],[201,1,202,1],[203,0,204,0],[203,1,204,1],[193,0,194,0],[193,1,194,1],[195,0,196,0],[195,1,196,1],[197,0,198,0],[197,1,198,1],[187,0,188,0],[187,1,188,1],[189,0,190,0],[189,1,190,1],[191,0,192,0]]}
["TRAINING INVOICE",null,null,null,null,null,null,null,null,null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
["SUBRECIPIENTS AND VENDORS"]
["Subrecipients Summary"]
["Budget Worksheet Reference ID","Subrecipient Name","Funding Category","Subrecipient Agreement  Budget","Subrecipient  Request This Period","Subrecipient Cumulative Expenses Billed to Date","Subrecipient  Balance","Subrecipient Exempt from Retention?","Billed CEC\nExpenses\nwithout Retention"]
["S-1","M&M, Inc.","CEC",50000,9257.26,15636.523999999999,{"$f":"ROUND(D5,2)-ROUND(F5,2)","v":34363.479999999996},"No",{"$f":"IF(H5=\"Yes\",ROUND(E5,2),0)","v":0}]
[null,null,"Match",30000,5137.6099999999997,7717.5499999999993,{"$f":"ROUND(D6,2)-ROUND(F6,2)","v":22282.45}]
["S-1","ABC National Lab","CEC",50000,11635.71,17103.939999999999,32896.06,"Yes",{"$f":"IF(H7=\"Yes\",ROUND(E7,2),0)","v":11635.71}]
[null,null,"Match",40000,8267.43,9952.2999999999993,30047.7]
[null,"Subrecipient 3","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H9=\"Yes\",ROUND(E9,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 4","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H11=\"Yes\",ROUND(E11,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 5","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H13=\"Yes\",ROUND(E13,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 6","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H15=\"Yes\",ROUND(E15,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 7","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H17=\"Yes\",ROUND(E17,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 8","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H19=\"Yes\",ROUND(E19,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 9","CEC",0,0,0,{"$f":"ROUND(D21,2)-ROUND(F21,2)","v":0},"Select Yes or No",{"$f":"IF(H21=\"Yes\",ROUND(E21,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 10","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H23=\"Yes\",ROUND(E23,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 11","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H25=\"Yes\",ROUND(E25,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 12","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H27=\"Yes\",ROUND(E27,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 13","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H29=\"Yes\",ROUND(E29,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 14","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H31=\"Yes\",ROUND(E31,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 15","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H33=\"Yes\",ROUND(E33,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 16","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H35=\"Yes\",ROUND(E35,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 17","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H37=\"Yes\",ROUND(E37,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 18","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H39=\"Yes\",ROUND(E39,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 19","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H41=\"Yes\",ROUND(E41,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 20","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H43=\"Yes\",ROUND(E43,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 21","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H45=\"Yes\",ROUND(E45,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 22","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H47=\"Yes\",ROUND(E47,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 23","CEC",0,0,0,{"$f":"ROUND(D49,2)-ROUND(F49,2)","v":0},"Select Yes or No",{"$f":"IF(H49=\"Yes\",ROUND(E49,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 24","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H51=\"Yes\",ROUND(E51,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 25","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H53=\"Yes\",ROUND(E53,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 26","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H55=\"Yes\",ROUND(E55,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 27","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H57=\"Yes\",ROUND(E57,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 28","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H59=\"Yes\",ROUND(E59,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 29","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H61=\"Yes\",ROUND(E61,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 30","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H63=\"Yes\",ROUND(E63,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 31","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H65=\"Yes\",ROUND(E65,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 32","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H67=\"Yes\",ROUND(E67,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 33","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H69=\"Yes\",ROUND(E69,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 34","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H71=\"Yes\",ROUND(E71,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 35","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H73=\"Yes\",ROUND(E73,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 36","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H75=\"Yes\",ROUND(E75,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 37","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H77=\"Yes\",ROUND(E77,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 38","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H79=\"Yes\",ROUND(E79,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 39","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H81=\"Yes\",ROUND(E81,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 40","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H83=\"Yes\",ROUND(E83,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 41","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H85=\"Yes\",ROUND(E85,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 42","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H87=\"Yes\",ROUND(E87,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 43","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H89=\"Yes\",ROUND(E89,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 44","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H91=\"Yes\",ROUND(E91,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 45","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H93=\"Yes\",ROUND(E93,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 46","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H95=\"Yes\",ROUND(E95,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 47","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H97=\"Yes\",ROUND(E97,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
[null,"Subrecipient 48","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H99=\"Yes\",ROUND(E99,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
["CEC USE ONLY","Subrecipient 49","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H101=\"Yes\",ROUND(E101,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
["CEC USE ONLY","Subrecipient 50","CEC",0,0,0,0,"Select Yes or No",{"$f":"IF(H103=\"Yes\",ROUND(E103,2),0)","v":0}]
[null,null,"Match",0,0,0,0]
["Subrecipient Totals",null,"CEC",{"$f":"ROUND(D5,0)+ROUND(D7,0)+ROUND(D9,0)+ROUND(D11,0)+ROUND(D13,0)+ROUND(D15,0)+ROUND(D17,0)+ROUND(D19,0)+ROUND(D21,0)+ROUND(D23,0)+ROUND(D25,0)+ROUND(D27,0)+ROUND(D29,0)+ROUND(D31,0)+ROUND(D33,0)+ROUND(D35,0)+ROUND(D37,0)+ROUND(D39,0)+ROUND(D41,0)+ROUND(D43,0)+ROUND(D45,0)+ROUND(D47,0)+ROUND(D49,0)+ROUND(D51,0)+ROUND(D53,0)+ROUND(D55,0)+ROUND(D57,0)+ROUND(D59,0)+ROUND(D61,0)+ROUND(D63,0)+ROUND(D65,0)+ROUND(D67,0)+ROUND(D69,0)+ROUND(D71,0)+ROUND(D73,0)+ROUND(D75,0)+ROUND(D77,0)+ROUND(D79,0)+ROUND(D81,0)+ROUND(D83,0)+ROUND(D85,0)+ROUND(D87,0)+ROUND(D89,0)+ROUND(D91,0)+ROUND(D93,0)+ROUND(D95,0)+ROUND(D97,0)+ROUND(D99,0)+ROUND(D101,0)+ROUND(D103,0)","v":100000},{"$f":"ROUND(E5,2)+ROUND(E7,2)+ROUND(E9,2)+ROUND(E11,2)+ROUND(E13,2)+ROUND(E15,2)+ROUND(E17,2)+ROUND(E19,2)+ROUND(E21,2)+ROUND(E23,2)+ROUND(E25,2)+ROUND(E27,2)+ROUND(E29,2)+ROUND(E31,2)+ROUND(E33,2)+ROUND(E35,2)+ROUND(E37,2)+ROUND(E39,2)+ROUND(E41,2)+ROUND(E43,2)+ROUND(E45,2)+ROUND(E47,2)+ROUND(E49,2)+ROUND(E51,2)+ROUND(E53,2)+ROUND(E55,2)+ROUND(E57,2)+ROUND(E59,2)+ROUND(E61,2)+ROUND(E63,2)+ROUND(E65,2)+ROUND(E67,2)+ROUND(E69,2)+ROUND(E71,2)+ROUND(E73,2)+ROUND(E75,2)+ROUND(E77,2)+ROUND(E79,2)+ROUND(E81,2)+ROUND(E83,2)+ROUND(E85,2)+ROUND(E87,2)+ROUND(E89,2)+ROUND(E91,2)+ROUND(E93,2)+ROUND(E95,2)+ROUND(E97,2)+ROUND(E99,2)+ROUND(E101,2)+ROUND(E103,2)","v":20892.97},{"$f":"ROUND(F5,2)+ROUND(F7,2)+ROUND(F9,2)+ROUND(F11,2)+ROUND(F13,2)+ROUND(F15,2)+ROUND(F17,2)+ROUND(F19,2)+ROUND(F21,2)+ROUND(F23,2)+ROUND(F25,2)+ROUND(F27,2)+ROUND(F29,2)+ROUND(F31,2)+ROUND(F33,2)+ROUND(F35,2)+ROUND(F37,2)+ROUND(F39,2)+ROUND(F41,2)+ROUND(F43,2)+ROUND(F45,2)+ROUND(F47,2)+ROUND(F49,2)+ROUND(F51,2)+ROUND(F53,2)+ROUND(F55,2)+ROUND(F57,2)+ROUND(F59,2)+ROUND(F61,2)+ROUND(F63,2)+ROUND(F65,2)+ROUND(F67,2)+ROUND(F69,2)+ROUND(F71,2)+ROUND(F73,2)+ROUND(F75,2)+ROUND(F77,2)+ROUND(F79,2)+ROUND(F81,2)+ROUND(F83,2)+ROUND(F85,2)+ROUND(F87,2)+ROUND(F89,2)+ROUND(F91,2)+ROUND(F93,2)+ROUND(F95,2)+ROUND(F97,2)+ROUND(F99,2)+ROUND(F101,2)+ROUND(F103,2)","v":32740.46},{"$f":"ROUND(D105,2)-ROUND(F105,2)","v":67259.540000000008},"Grand Total  ",{"$f":"SUM(I5:I104)","v":11635.71}]
[null,null,"Match",{"$f":"ROUND(D6,0)+ROUND(D8,0)+ROUND(D10,0)+ROUND(D12,0)+ROUND(D14,0)+ROUND(D16,0)+ROUND(D18,0)+ROUND(D20,0)+ROUND(D22,0)+ROUND(D24,0)+ROUND(D26,0)+ROUND(D28,0)+ROUND(D30,0)+ROUND(D32,0)+ROUND(D34,0)+ROUND(D36,0)+ROUND(D38,0)+ROUND(D40,0)+ROUND(D42,0)+ROUND(D44,0)+ROUND(D46,0)+ROUND(D48,0)+ROUND(D50,0)+ROUND(D52,0)+ROUND(D54,0)+ROUND(D56,0)+ROUND(D58,0)+ROUND(D60,0)+ROUND(D62,0)+ROUND(D64,0)+ROUND(D66,0)+ROUND(D68,0)+ROUND(D70,0)+ROUND(D72,0)+ROUND(D74,0)+ROUND(D76,0)+ROUND(D78,0)+ROUND(D80,0)+ROUND(D82,0)+ROUND(D84,0)+ROUND(D86,0)+ROUND(D88,0)+ROUND(D90,0)+ROUND(D92,0)+ROUND(D94,0)+ROUND(D96,0)+ROUND(D98,0)+ROUND(D100,0)+ROUND(D102,0)+ROUND(D104,0)","v":70000},{"$f":"ROUND(E6,2)+ROUND(E8,2)+ROUND(E10,2)+ROUND(E12,2)+ROUND(E14,2)+ROUND(E16,2)+ROUND(E18,2)+ROUND(E20,2)+ROUND(E22,2)+ROUND(E24,2)+ROUND(E26,2)+ROUND(E28,2)+ROUND(E30,2)+ROUND(E32,2)+ROUND(E34,2)+ROUND(E36,2)+ROUND(E38,2)+ROUND(E40,2)+ROUND(E42,2)+ROUND(E44,2)+ROUND(E46,2)+ROUND(E48,2)+ROUND(E50,2)+ROUND(E52,2)+ROUND(E54,2)+ROUND(E56,2)+ROUND(E58,2)+ROUND(E60,2)+ROUND(E62,2)+ROUND(E64,2)+ROUND(E66,2)+ROUND(E68,2)+ROUND(E70,2)+ROUND(E72,2)+ROUND(E74,2)+ROUND(E76,2)+ROUND(E78,2)+ROUND(E80,2)+ROUND(E82,2)+ROUND(E84,2)+ROUND(E86,2)+ROUND(E88,2)+ROUND(E90,2)+ROUND(E92,2)+ROUND(E94,2)+ROUND(E96,2)+ROUND(E98,2)+ROUND(E100,2)+ROUND(E102,2)+ROUND(E104,2)","v":13405.04},{"$f":"ROUND(F6,2)+ROUND(F8,2)+ROUND(F10,2)+ROUND(F12,2)+ROUND(F14,2)+ROUND(F16,2)+ROUND(F18,2)+ROUND(F20,2)+ROUND(F22,2)+ROUND(F24,2)+ROUND(F26,2)+ROUND(F28,2)+ROUND(F30,2)+ROUND(F32,2)+ROUND(F34,2)+ROUND(F36,2)+ROUND(F38,2)+ROUND(F40,2)+ROUND(F42,2)+ROUND(F44,2)+ROUND(F46,2)+ROUND(F48,2)+ROUND(F50,2)+ROUND(F52,2)+ROUND(F54,2)+ROUND(F56,2)+ROUND(F58,2)+ROUND(F60,2)+ROUND(F62,2)+ROUND(F64,2)+ROUND(F66,2)+ROUND(F68,2)+ROUND(F70,2)+ROUND(F72,2)+ROUND(F74,2)+ROUND(F76,2)+ROUND(F78,2)+ROUND(F80,2)+ROUND(F82,2)+ROUND(F84,2)+ROUND(F86,2)+ROUND(F88,2)+ROUND(F90,2)+ROUND(F92,2)+ROUND(F94,2)+ROUND(F96,2)+ROUND(F98,2)+ROUND(F100,2)+ROUND(F102,2)+ROUND(F104,2)","v":17669.849999999999},{"$f":"ROUND(D106,2)-ROUND(F106,2)","v":52330.15}]
[]
["Vendors Summary"]
["Budget Worksheet Reference ID","Vendor Name","Funding Category","Vendor Agreement  Budget","Vendor Expenses This Period","Vendor Cumulative Spent to Date","Vendor Balance"]
["V-1","Alpha Security, Inc.","CEC",1000,982.36,0,{"$f":"ROUND(D110,2)-ROUND(F110,2)","v":1000}]
[null,null,"Match",1000,893.79,0,{"$f":"ROUND(D111,2)-ROUND(F111,2)","v":1000}]
[null,"Vendor 2","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 3","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 4","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 5","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 6","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 7","CEC",0,0,0,0]
[null,null,"Match",0,0,0,{"$f":"ROUND(D123,2)-ROUND(F123,2)","v":0}]
[null,"Vendor 8","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 9","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 10","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 11","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 12","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 13","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 14","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 15","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 16","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 17","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 18","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 19","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 20","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 21","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 22","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 23","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 24","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 25","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 26","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 27","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 28","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 29","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 30","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 31","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 32","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 33","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 34","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 35","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 36","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 37","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 38","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 39","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 40","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 41","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 42","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 43","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 44","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 45","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 46","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 47","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
[null,"Vendor 48","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
["CEC USE ONLY","Vendor 49","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
["CEC USE ONLY","Vendor 50","CEC",0,0,0,0]
[null,null,"Match",0,0,0,0]
["Vendor Totals",null,"CEC",{"$f":"ROUND(D110,0)+ROUND(D112,0)+ROUND(D114,0)+ROUND(D116,0)+ROUND(D118,0)+ROUND(D120,0)+ROUND(D122,0)+ROUND(D124,0)+ROUND(D126,0)+ROUND(D128,0)+ROUND(D130,0)+ROUND(D132,0)+ROUND(D134,0)+ROUND(D136,0)+ROUND(D138,0)+ROUND(D140,0)+ROUND(D142,0)+ROUND(D144,0)+ROUND(D146,0)+ROUND(D148,0)+ROUND(D150,0)+ROUND(D152,0)+ROUND(D154,0)+ROUND(D156,0)+ROUND(D158,0)+ROUND(D160,0)+ROUND(D162,0)+ROUND(D164,0)+ROUND(D166,0)+ROUND(D168,0)+ROUND(D170,0)+ROUND(D172,0)+ROUND(D174,0)+ROUND(D176,0)+ROUND(D178,0)+ROUND(D180,0)+ROUND(D182,0)+ROUND(D184,0)+ROUND(D186,0)+ROUND(D188,0)+ROUND(D190,0)+ROUND(D192,0)+ROUND(D194,0)+ROUND(D196,0)+ROUND(D198,0)+ROUND(D200,0)+ROUND(D202,0)+ROUND(D204,0)+ROUND(D206,0)+ROUND(D208,0)","v":1000},{"$f":"ROUND(E110,2)+ROUND(E112,2)+ROUND(E114,2)+ROUND(E116,2)+ROUND(E118,2)+ROUND(E120,2)+ROUND(E122,2)+ROUND(E124,2)+ROUND(E126,2)+ROUND(E128,2)+ROUND(E130,2)+ROUND(E132,2)+ROUND(E134,2)+ROUND(E136,2)+ROUND(E138,2)+ROUND(E140,2)+ROUND(E142,2)+ROUND(E144,2)+ROUND(E146,2)+ROUND(E148,2)+ROUND(E150,2)+ROUND(E152,2)+ROUND(E154,2)+ROUND(E156,2)+ROUND(E158,2)+ROUND(E160,2)+ROUND(E162,2)+ROUND(E164,2)+ROUND(E166,2)+ROUND(E168,2)+ROUND(E170,2)+ROUND(E172,2)+ROUND(E174,2)+ROUND(E176,2)+ROUND(E178,2)+ROUND(E180,2)+ROUND(E182,2)+ROUND(E184,2)+ROUND(E186,2)+ROUND(E188,2)+ROUND(E190,2)+ROUND(E192,2)+ROUND(E194,2)+ROUND(E196,2)+ROUND(E198,2)+ROUND(E200,2)+ROUND(E202,2)+ROUND(E204,2)+ROUND(E206,2)+ROUND(E208,2)","v":982.36},{"$f":"ROUND(F110,2)+ROUND(F112,2)+ROUND(F114,2)+ROUND(F116,2)+ROUND(F118,2)+ROUND(F120,2)+ROUND(F122,2)+ROUND(F124,2)+ROUND(F126,2)+ROUND(F128,2)+ROUND(F130,2)+ROUND(F132,2)+ROUND(F134,2)+ROUND(F136,2)+ROUND(F138,2)+ROUND(F140,2)+ROUND(F142,2)+ROUND(F144,2)+ROUND(F146,2)+ROUND(F148,2)+ROUND(F150,2)+ROUND(F152,2)+ROUND(F154,2)+ROUND(F156,2)+ROUND(F158,2)+ROUND(F160,2)+ROUND(F162,2)+ROUND(F164,2)+ROUND(F166,2)+ROUND(F168,2)+ROUND(F170,2)+ROUND(F172,2)+ROUND(F174,2)+ROUND(F176,2)+ROUND(F178,2)+ROUND(F180,2)+ROUND(F182,2)+ROUND(F184,2)+ROUND(F186,2)+ROUND(F188,2)+ROUND(F190,2)+ROUND(F192,2)+ROUND(F194,2)+ROUND(F196,2)+ROUND(F198,2)+ROUND(F200,2)+ROUND(F202,2)+ROUND(F204,2)+ROUND(F206,2)+ROUND(F208,2)","v":0},1000]
[null,null,"Match",{"$f":"ROUND(D111,0)+ROUND(D113,0)+ROUND(D115,0)+ROUND(D117,0)+ROUND(D119,0)+ROUND(D121,0)+ROUND(D123,0)+ROUND(D125,0)+ROUND(D127,0)+ROUND(D129,0)+ROUND(D131,0)+ROUND(D133,0)+ROUND(D135,0)+ROUND(D137,0)+ROUND(D139,0)+ROUND(D141,0)+ROUND(D143,0)+ROUND(D145,0)+ROUND(D147,0)+ROUND(D149,0)+ROUND(D151,0)+ROUND(D153,0)+ROUND(D155,0)+ROUND(D157,0)+ROUND(D159,0)+ROUND(D161,0)+ROUND(D163,0)+ROUND(D165,0)+ROUND(D167,0)+ROUND(D169,0)+ROUND(D171,0)+ROUND(D173,0)+ROUND(D175,0)+ROUND(D177,0)+ROUND(D179,0)+ROUND(D181,0)+ROUND(D183,0)+ROUND(D185,0)+ROUND(D187,0)+ROUND(D189,0)+ROUND(D191,0)+ROUND(D193,0)+ROUND(D195,0)+ROUND(D197,0)+ROUND(D199,0)+ROUND(D201,0)+ROUND(D203,0)+ROUND(D205,0)+ROUND(D207,0)+ROUND(D209,0)","v":1000},{"$f":"ROUND(E111,2)+ROUND(E113,2)+ROUND(E115,2)+ROUND(E117,2)+ROUND(E119,2)+ROUND(E121,2)+ROUND(E123,2)+ROUND(E125,2)+ROUND(E127,2)+ROUND(E129,2)+ROUND(E131,2)+ROUND(E133,2)+ROUND(E135,2)+ROUND(E137,2)+ROUND(E139,2)+ROUND(E141,2)+ROUND(E143,2)+ROUND(E145,2)+ROUND(E147,2)+ROUND(E149,2)+ROUND(E151,2)+ROUND(E153,2)+ROUND(E155,2)+ROUND(E157,2)+ROUND(E159,2)+ROUND(E161,2)+ROUND(E163,2)+ROUND(E165,2)+ROUND(E167,2)+ROUND(E169,2)+ROUND(E171,2)+ROUND(E173,2)+ROUND(E175,2)+ROUND(E177,2)+ROUND(E179,2)+ROUND(E181,2)+ROUND(E183,2)+ROUND(E185,2)+ROUND(E187,2)+ROUND(E189,2)+ROUND(E191,2)+ROUND(E193,2)+ROUND(E195,2)+ROUND(E197,2)+ROUND(E199,2)+ROUND(E201,2)+ROUND(E203,2)+ROUND(E205,2)+ROUND(E207,2)+ROUND(E209,2)","v":893.79},{"$f":"ROUND(F111,2)+ROUND(F113,2)+ROUND(F115,2)+ROUND(F117,2)+ROUND(F119,2)+ROUND(F121,2)+ROUND(F123,2)+ROUND(F125,2)+ROUND(F127,2)+ROUND(F129,2)+ROUND(F131,2)+ROUND(F133,2)+ROUND(F135,2)+ROUND(F137,2)+ROUND(F139,2)+ROUND(F141,2)+ROUND(F143,2)+ROUND(F145,2)+ROUND(F147,2)+ROUND(F149,2)+ROUND(F151,2)+ROUND(F153,2)+ROUND(F155,2)+ROUND(F157,2)+ROUND(F159,2)+ROUND(F161,2)+ROUND(F163,2)+ROUND(F165,2)+ROUND(F167,2)+ROUND(F169,2)+ROUND(F171,2)+ROUND(F173,2)+ROUND(F175,2)+ROUND(F177,2)+ROUND(F179,2)+ROUND(F181,2)+ROUND(F183,2)+ROUND(F185,2)+ROUND(F187,2)+ROUND(F189,2)+ROUND(F191,2)+ROUND(F193,2)+ROUND(F195,2)+ROUND(F197,2)+ROUND(F199,2)+ROUND(F201,2)+ROUND(F203,2)+ROUND(F205,2)+ROUND(F207,2)+ROUND(F209,2)","v":0},1000]
[]
["Subrecipients & Vendors Grand Totals"]
[null,null,null,"Agreement  Budget","Expenses This Period","Cumulative Spent to Date","Balance"]
["Grand Totals",null,"CEC",{"$f":"D105+D210","v":101000},21875.33,32740.46,{"$f":"ROUND(D215,2)-ROUND(F215,2)","v":68259.540000000008}]
[null,null,"Match",71000,14298.830000000002,17669.849999999999,{"$f":"ROUND(D216,2)-ROUND(F216,2)","v":53330.15}]

{"sheet":"Indirect Costs & Profit","index":8,"n_rows":160,"n_cols":17,"rows_kept":160,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[4,0,10,0],[4,4,10,4],[4,5,10,5],[4,6,10,6],[4,7,10,7],[4,8,10,8],[4,9,10,9],[4,10,10,10],[4,11,10,11],[11,0,17,0],[11,4,17,4],[11,5,17,5],[11,6,17,6],[11,7,17,7],[11,8,17,8],[11,9,17,9],[11,10,17,10],[11,11,17,11],[18,0,24,0],[18,4,24,4],[18,5,24,5],[18,6,24,6],[18,7,24,7],[18,8,24,8],[18,9,24,9],[18,10,24,10],[18,11,24,11],[25,0,31,0],[25,4,31,4],[25,5,31,5],[25,6,31,6],[25,7,31,7],[25,8,31,8],[25,9,31,9],[25,10,31,10],[25,11,31,11],[32,0,38,0],[32,4,38,4],[32,5,38,5],[32,6,38,6],[32,7,38,7],[32,8,38,8],[32,9,38,9],[32,10,38,10],[32,11,38,11],[39,9,45,9],[39,10,45,10],[39,11,45,11],[46,0,52,0],[46,4,52,4],[46,5,52,5],[46,6,52,6],[46,7,52,7],[46,8,52,8],[46,9,52,9],[39,0,45,0],[39,4,45,4],[39,5,45,5],[39,6,45,6],[39,7,45,7],[39,8,45,8],[46,10,52,10],[46,11,52,11],[53,0,59,0],[53,4,59,4],[53,5,59,5],[53,6,59,6],[53,7,59,7],[53,8,59,8],[53,9,59,9],[53,10,59,10],[53,11,59,11],[60,0,66,0],[60,4,66,4],[60,5,66,5],[60,6,66,6],[60,7,66,7],[60,8,66,8],[60,9,66,9],[60,10,66,10],[60,11,66,11],[67,9,73,9],[67,10,73,10],[67,11,73,11],[74,0,80,0],[74,4,80,4],[74,5,80,5],[74,6,80,6],[74,7,80,7],[74,8,80,8],[74,9,80,9],[67,0,73,0],[67,4,73,4],[67,5,73,5],[67,6,73,6],[67,7,73,7],[67,8,73,8],[74,10,80,10],[74,11,80,11],[81,0,87,0],[81,4,87,4],[81,5,87,5],[81,6,87,6],[81,7,87,7],[81,8,87,8],[81,9,87,9],[81,10,87,10],[81,11,87,11],[88,0,94,0],[88,4,94,4],[88,5,94,5],[88,6,94,6],[88,7,94,7],[88,8,94,8],[88,9,94,9],[88,10,94,10],[88,11,94,11],[95,9,101,9],[95,10,101,10],[95,11,101,11],[102,0,108,0],[102,4,108,4],[102,5,108,5],[102,6,108,6],[102,7,108,7],[102,8,108,8],[102,9,108,9],[95,0,101,0],[95,4,101,4],[95,5,101,5],[95,6,101,6],[95,7,101,7],[95,8,101,8],[102,10,108,10],[102,11,108,11],[109,0,115,0],[109,4,115,4],[109,5,115,5],[109,6,115,6],[109,7,115,7],[109,8,115,8],[109,9,115,9],[109,10,115,10],[109,11,115,11],[116,0,122,0],[116,4,122,4],[116,5,122,5],[116,6,122,6],[116,7,122,7],[116,8,122,8],[116,9,122,9],[116,10,122,10],[116,11,122,11],[123,9,129,9],[123,10,129,10],[123,11,129,11],[130,0,136,0],[130,4,136,4],[130,5,136,5],[130,6,136,6],[130,7,136,7],[130,8,136,8],[130,9,136,9],[123,0,129,0],[123,4,129,4],[123,5,129,5],[123,6,129,6],[123,7,129,7],[123,8,129,8],[130,10,136,10],[130,11,136,11],[137,0,143,0],[137,4,143,4],[137,5,143,5],[137,6,143,6],[137,7,143,7],[137,8,143,8],[137,9,143,9],[137,10,143,10],[137,11,143,11],[144,0,144,8],[146,0,146,11],[147,0,147,1],[148,0,148,1],[148,4,154,4],[148,5,154,5],[148,6,154,6],[148,7,154,7],[148,8,154,8],[155,0,155,8],[157,0,157,11],[158,0,158,11],[159,0,159,11],[148,9,154,9],[148,10,154,10],[148,11,154,11],[149,0,149,1],[150,0,150,1],[151,0,151,1],[152,0,152,1],[153,0,153,1],[154,0,154,1]]}
["TRAINING INVOICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANDBOX AREA (highlighted in light red)- For rough work associated with the print area to the left.  Rough work may include, notes, calculations, derivations, etc."]
["Indirect Costs and Profit"]
["Indirect Cost(s)"]
["Name of Indirect Cost","Indirect Cost (IDC) Base Category","IDC Base\nCEC Share\nBilled\nThis Period ($)","IDC Base\nMatch Share\nExpenses\nThis Period ($)","Total \nIDC Base\nCEC Share\nBilled\nThis Period ($)","Total \nIDC Base\nMatch Share\nExpenses\nThis Period ($)","Total IDC Base\nBilled/Match\nThis Period ($)","IDC Actual Rate\nBilled/Match\nThis Period (%)","Rate x Base ($)","Billed\nCEC Expenses","Match \nShare\nExpenses","Total"]
["Overhead","Direct Labor",{"$f":"'Invoice Summary'!$C$13","v":10972.9},{"$f":"'Invoice Summary'!$C$25","v":2000},{"$f":"SUM(ROUND(C5,2),ROUND(C6,2),ROUND(C7,2),ROUND(C8,2),ROUND(C9,2),ROUND(C10,2),ROUND(C11,2))","v":67195.239999999991},{"$f":"SUM(ROUND(D5,2),ROUND(D6,2),ROUND(D7,2),ROUND(D8,2),ROUND(D9,2),ROUND(D10,2),ROUND(D11,2))","v":24084.440000000002},{"$f":"SUM(E5,F5)","v":91279.679999999993},0.2,{"$f":"ROUND($G5*H5,2)","v":18255.939999999999},{"$f":"6136.53+0.01","v":6136.54},1620,{"$f":"ROUND($J5,2)+ROUND($K5,2)","v":7756.54}]
[null,"Fringe Benefits",{"$f":"'Invoice Summary'!$C$14","v":4609.76},{"$f":"'Invoice Summary'!$C$26","v":600}]
[null,"Travel",{"$f":"'Invoice Summary'!$C$15","v":78.63},{"$f":"'Invoice Summary'!$C$27","v":21.56}]
[null,"Equipment",0,0]
[null,"Materials/Misc.",{"$f":"'Invoice Summary'!$C$17","v":29658.62},{"$f":"'Invoice Summary'!$C$29","v":7164.0499999999993}]
[null,"Subrecipients/Vendors",{"$f":"'Invoice Summary'!$C$18","v":21875.33},{"$f":"'Invoice Summary'!$C$30","v":14298.830000000002}]
[null,"Indirect Cost",0,0]
["G&A","Direct Labor",100.49,100.49,{"$f":"SUM(ROUND(C12,2),ROUND(C13,2),ROUND(C14,2),ROUND(C15,2),ROUND(C16,2),ROUND(C17,2),ROUND(C18,2))","v":200.98},200.98,{"$f":"SUM(E12,F12)","v":401.96},0.1,{"$f":"ROUND($G12*H12,2)","v":40.200000000000003},{"$f":"20.098+0.01","v":20.108000000000001},20.09,{"$f":"ROUND($J12,2)+ROUND($K12,2)","v":40.200000000000003}]
[null,"Fringe Benefits",100.49,100.49]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C19,2),ROUND(C20,2),ROUND(C21,2),ROUND(C22,2),ROUND(C23,2),ROUND(C24,2),ROUND(C25,2))","v":0},0,{"$f":"SUM(E19,F19)","v":0},0,{"$f":"ROUND($G19*H19,2)","v":0},0,0,{"$f":"ROUND($J19,2)+ROUND($K19,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C26,2),ROUND(C27,2),ROUND(C28,2),ROUND(C29,2),ROUND(C30,2),ROUND(C31,2),ROUND(C32,2))","v":0},0,{"$f":"SUM(E26,F26)","v":0},0,{"$f":"ROUND($G26*H26,2)","v":0},0,0,{"$f":"ROUND($J26,2)+ROUND($K26,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C33,2),ROUND(C34,2),ROUND(C35,2),ROUND(C36,2),ROUND(C37,2),ROUND(C38,2),ROUND(C39,2))","v":0},0,{"$f":"SUM(E33,F33)","v":0},0,{"$f":"ROUND($G33*H33,2)","v":0},0,0,{"$f":"ROUND($J33,2)+ROUND($K33,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C40,2),ROUND(C41,2),ROUND(C42,2),ROUND(C43,2),ROUND(C44,2),ROUND(C45,2),ROUND(C46,2))","v":0},0,{"$f":"SUM(E40,F40)","v":0},0,{"$f":"ROUND($G40*H40,2)","v":0},0,0,{"$f":"ROUND($J40,2)+ROUND($K40,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C47,2),ROUND(C48,2),ROUND(C49,2),ROUND(C50,2),ROUND(C51,2),ROUND(C52,2),ROUND(C53,2))","v":0},0,{"$f":"SUM(E47,F47)","v":0},0,{"$f":"ROUND($G47*H47,2)","v":0},0,0,{"$f":"ROUND($J47,2)+ROUND($K47,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C54,2),ROUND(C55,2),ROUND(C56,2),ROUND(C57,2),ROUND(C58,2),ROUND(C59,2),ROUND(C60,2))","v":0},0,{"$f":"SUM(E54,F54)","v":0},0,{"$f":"ROUND($G54*H54,2)","v":0},0,0,{"$f":"ROUND($J54,2)+ROUND($K54,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C61,2),ROUND(C62,2),ROUND(C63,2),ROUND(C64,2),ROUND(C65,2),ROUND(C66,2),ROUND(C67,2))","v":0},0,{"$f":"SUM(E61,F61)","v":0},0,{"$f":"ROUND($G61*H61,2)","v":0},0,0,{"$f":"ROUND($J61,2)+ROUND($K61,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C68,2),ROUND(C69,2),ROUND(C70,2),ROUND(C71,2),ROUND(C72,2),ROUND(C73,2),ROUND(C74,2))","v":0},0,{"$f":"SUM(E68,F68)","v":0},0,{"$f":"ROUND($G68*H68,2)","v":0},0,0,{"$f":"ROUND($J68,2)+ROUND($K68,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C75,2),ROUND(C76,2),ROUND(C77,2),ROUND(C78,2),ROUND(C79,2),ROUND(C80,2),ROUND(C81,2))","v":0},0,{"$f":"SUM(E75,F75)","v":0},0,{"$f":"ROUND($G75*H75,2)","v":0},0,0,{"$f":"ROUND($J75,2)+ROUND($K75,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C82,2),ROUND(C83,2),ROUND(C84,2),ROUND(C85,2),ROUND(C86,2),ROUND(C87,2),ROUND(C88,2))","v":0},0,{"$f":"SUM(E82,F82)","v":0},0,{"$f":"ROUND($G82*H82,2)","v":0},0,0,{"$f":"ROUND($J82,2)+ROUND($K82,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C89,2),ROUND(C90,2),ROUND(C91,2),ROUND(C92,2),ROUND(C93,2),ROUND(C94,2),ROUND(C95,2))","v":0},0,{"$f":"SUM(E89,F89)","v":0},0,{"$f":"ROUND($G89*H89,2)","v":0},0,0,{"$f":"ROUND($J89,2)+ROUND($K89,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C96,2),ROUND(C97,2),ROUND(C98,2),ROUND(C99,2),ROUND(C100,2),ROUND(C101,2),ROUND(C102,2))","v":0},0,{"$f":"SUM(E96,F96)","v":0},0,{"$f":"ROUND($G96*H96,2)","v":0},0,0,{"$f":"ROUND($J96,2)+ROUND($K96,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C103,2),ROUND(C104,2),ROUND(C105,2),ROUND(C106,2),ROUND(C107,2),ROUND(C108,2),ROUND(C109,2))","v":0},0,{"$f":"SUM(E103,F103)","v":0},0,{"$f":"ROUND($G103*H103,2)","v":0},0,0,{"$f":"ROUND($J103,2)+ROUND($K103,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C110,2),ROUND(C111,2),ROUND(C112,2),ROUND(C113,2),ROUND(C114,2),ROUND(C115,2),ROUND(C116,2))","v":0},0,{"$f":"SUM(E110,F110)","v":0},0,{"$f":"ROUND($G110*H110,2)","v":0},0,0,{"$f":"ROUND($J110,2)+ROUND($K110,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C117,2),ROUND(C118,2),ROUND(C119,2),ROUND(C120,2),ROUND(C121,2),ROUND(C122,2),ROUND(C123,2))","v":0},0,{"$f":"SUM(E117,F117)","v":0},0,{"$f":"ROUND($G117*H117,2)","v":0},0,0,{"$f":"ROUND($J117,2)+ROUND($K117,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
[null,"Direct Labor",0,0,{"$f":"SUM(ROUND(C124,2),ROUND(C125,2),ROUND(C126,2),ROUND(C127,2),ROUND(C128,2),ROUND(C129,2),ROUND(C130,2))","v":0},0,{"$f":"SUM(E124,F124)","v":0},0,{"$f":"ROUND($G124*H124,2)","v":0},0,0,{"$f":"ROUND($J124,2)+ROUND($K124,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
["CEC USE ONLY","Direct Labor",0,0,{"$f":"SUM(ROUND(C131,2),ROUND(C132,2),ROUND(C133,2),ROUND(C134,2),ROUND(C135,2),ROUND(C136,2),ROUND(C137,2))","v":0},0,{"$f":"SUM(E131,F131)","v":0},0,{"$f":"ROUND($G131*H131,2)","v":0},0,0,{"$f":"ROUND($J131,2)+ROUND($K131,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
["CEC USE ONLY","Direct Labor",0,0,{"$f":"SUM(ROUND(C138,2),ROUND(C139,2),ROUND(C140,2),ROUND(C141,2),ROUND(C142,2),ROUND(C143,2),ROUND(C144,2))","v":0},{"$f":"SUM(ROUND(D138,2),ROUND(D139,2),ROUND(D140,2),ROUND(D141,2),ROUND(D142,2),ROUND(D143,2),ROUND(D144,2))","v":0},{"$f":"SUM(E138,F138)","v":0},0,{"$f":"ROUND($G138*H138,2)","v":0},0,0,{"$f":"ROUND($J138,2)+ROUND($K138,2)","v":0}]
[null,"Fringe Benefits",0,0]
[null,"Travel",0,0]
[null,"Equipment",0,0]
[null,"Materials/Misc.",0,0]
[null,"Subrecipients/Vendors",0,0]
[null,"Indirect Cost",0,0]
["Indirect Costs Grand Totals ",null,null,null,null,null,null,null,null,{"$f":"SUM(ROUND(J5:J144,2))","v":6156.65},{"$f":"SUM(ROUND(K5:K144,2))","v":1640.09},{"$f":"SUM(L5:L144)","v":7796.74}]
[]
["Profit"]
["Profit Base Categories",null,"Profit Base\nCEC Share\nBilled\nThis Period ($)","Profit Base\nMatch Share\nExpenses\nThis Period ($)","Total \nProfit Base\nCEC Share\nBilled\nThis Period ($)","Total \nProfit Base\nMatch Share\nExpenses\nThis Period ($)","Total Profit Base\nBilled/Match\nThis Period ($)","Profit Rate\nBilled/Match\nThis Period (%)","Rate x Base ($)","Billed\nCEC Expenses","Match \nShare\nExpenses","Total"]
["Direct Labor",null,{"$f":"'Invoice Summary'!$C$13","v":10972.9},{"$f":"'Invoice Summary'!$C$25","v":2000},{"$f":"SUM(ROUND(C149,2),ROUND(C150,2),ROUND(C151,2),ROUND(C152,2),ROUND(C153,2),ROUND(C154,2),ROUND(C155,2))","v":15582.66},{"$f":"SUM(ROUND(D149,2),ROUND(D150,2),ROUND(D151,2),ROUND(D152,2),ROUND(D153,2),ROUND(D154,2),ROUND(D155,2))","v":2600},{"$f":"SUM(E149,F149)","v":18182.66},0.1,{"$f":"ROUND($G149*H149,2)","v":1818.27},{"$f":"1558.27+0","v":1558.27},260,{"$f":"ROUND($J149,2)+ROUND($K149,2)","v":1818.27}]
["Fringe Benefits",null,{"$f":"'Invoice Summary'!$C$14","v":4609.76},{"$f":"'Invoice Summary'!$C$26","v":600}]
["Travel",null,0,0]
["Equipment",null,0,0]
["Materials/Misc.",null,0,0]
["Subrecipients/Vendors",null,0,0]
["Indirect Cost",null,0,0]
["Profit Grand Totals ",null,null,null,null,null,null,null,null,{"$f":"SUM(ROUND(J149,2))","v":1558.27},{"$f":"SUM(ROUND(K149,2))","v":260},{"$f":"SUM(L149)","v":1818.27}]
[]
["Worksheet Specific Instructions"]
["CONDITIONAL FORMATTING APPLIED:  If the Billed CEC Expenses value is greater than the Total IDC Base CEC Share Billed ($) multiplied by the IDC Actual Rate (%), as indicated by red conditional formatting, then the invoice will have to be corrected and the Recipient notified that the CEC does not pay for Indirect Costs (IDCs) on IDC Base Amounts charged as Match Share expenses."]
["CONDITIONAL FORMATTING APPLIED:  If the Billed CEC Expenses value is greater than the Total Profit Base CEC Share Billed ($) multiplied by the Profit Rate (%), as indicated by red conditional formatting, then the invoice will have to be corrected and the Recipient notified that the CEC does not pay for Profit on Profit Base Amounts charged as Match Share expenses."]

{"sheet":"Lists","index":9,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Retention Method Selection"]
["Select a Retention Method"]
["Retention will be withheld at the end of the agreement (minus exempt subrecipients)"]
["Retention will be withheld from each invoice (minus exempt subrecipients)"]
["Retention is NOT required to be withheld for this agreement"]
[]
["End of Agreement Retention Method Situation"]
["If Applicable: \nSelect End of Agreement Retention Method Situation"]
["90.00%, or less, of CEC funds spent to date (minus exempt subrecipients), including this invoice"]
["With this invoice, percentage of CEC funds spent (minus exempt subrecipients) will transition from less than to greater than 90.00% [manually enter required retention amount below]"]
["More than 90.00% of CEC funds spent to date (minus exempt subrecipients), including this entire invoice"]
[]
["Invoice Selection"]
["Select Yes or No"]
["Yes"]
["No"]
["Subrecipient Exempt from Retention Selection"]
["Select Yes or No"]
["Yes"]
["No"]