{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["INPUT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"INPUT","index":0,"n_rows":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":false,"merged":[[62,4,62,6],[15,14,17,15],[19,9,20,9],[21,9,22,9],[0,1,0,10],[15,9,15,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"None or > $25K","All Contractual Svcs","> $100K"]
[null,"INDIRECT COST RATE",0.1]
[]
[null,null,null,null,"BASE","BASE","BASE",null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,"TOTAL SALARIES",null,null,{"$f":"IF(J17=\"no\",C15,0)","v":0},{"$f":"E15","v":0},{"$f":"E15","v":0},null,null,null,null,null,null,null,null,null,null,"No"]
[null,"TOTAL BENEFITS",null,null,{"$f":"IF(J18=\"no\",C16,0)","v":0},{"$f":"E16","v":0},{"$f":"E16","v":0},null,null,"Base Exclusions:"]
[null,"TOTAL EQUIPMENT",null,null,{"$f":"IF(J19=\"no\",C17,0)","v":0},0,{"$f":"E17","v":0},null,null,"No","Salaries"]
[null,"TOTAL CONTRACTUAL SERVICES:",{"$f":"SUM(C19:C28) + SUM(C30:C39)","v":0},null,{"$f":"SUM(E19:E39)","v":0},{"$f":"SUM(F19:F39)","v":0},{"$f":"SUM(G19:G39)","v":0},null,null,"No","Fringe"]
[null,"Subaward 1",null,null,{"$f":"IF($J$20=\"yes\",IF(C19>25000,25000,C19),C19)","v":0},{"$f":"IF($J$24=\"yes\",0,\"FALSE\")","v":"FALSE"},{"$f":"IF($J$22=\"yes\",IF(C19>100000,100000,C19),C19)","v":0},null,null,"Yes","Equipment"]
[null,"Subaward 2",null,null,0,{"$f":"IF($J$24=\"yes\",0,\"FALSE\")","v":"FALSE"},0,null,null,"Yes","Contractual Svcs> 1st $25K "]
[null,"Subaward 3",null,null,0,{"$f":"IF($J$24=\"yes\",0,\"FALSE\")","v":"FALSE"},0,null,null,null,"of each subaward"]
[null,"Subaward 4",null,null,0,{"$f":"IF($J$24=\"yes\",0,\"FALSE\")","v":"FALSE"},0,null,null,"No","Contractual Svcs> 1st $100K "]
[null,"Subaward 5",null,null,0,{"$f":"IF($J$24=\"yes\",0,\"FALSE\")","v":"FALSE"},0,null,null,null,"of each subaward or contract"]
[null,"Subaward 6",null,null,0,null,null,null,null,"No","Total Contractual Svcs"]
[null,"Subaward 7",null,null,0,null,null,null,null,"No","Supplies"]
[null,"Subaward 8",null,null,0,null,null,null,null,"No","Travel"]
[null,"Subaward 9",null,null,0,null,null,null,null,"No","Patient Care Costs"]
[null,"Subaward 10",null,null,0,null,null,null,null,"No","Rental Costs"]
[null,null,null,null,null,null,null,null,null,"No","Tuition"]
[null,"Contract 1",null,null,{"$f":"IF($J$20=\"YES\",C30,0)","v":0},null,null,null,null,"No","Scholarships/Fellowships"]
[null,"Contract 2",null,null,{"$f":"IF($J$20=\"YES\",C31,0)","v":0},null,null,null,null,"No","Participant Support Costs (Univ)"]
[null,"Contract 3",null,null,0,null,null,null,null,"No","Other ODCs"]
[null,"Contract 4",null,null,0,{"$f":"IF($J$24=\"yes\",0,\"FALSE\")","v":"FALSE"},0]
[null,"Contract 5",null,null,0,{"$f":"IF($J$24=\"yes\",0,\"FALSE\")","v":"FALSE"},0]
[null,"Contract 6",null,null,0,{"$f":"IF($J$24=\"yes\",0,\"FALSE\")","v":"FALSE"},0]
[null,"Contract 7",null,null,0]
[null,"Contract 8",null,null,0]
[null,"Contract 9",null,null,0,{"$f":"IF($J$24=\"yes\",0,\"FALSE\")","v":"FALSE"},0]
[null,"Contract 10",null,null,0,{"$f":"IF($J$24=\"yes\",0,\"FALSE\")","v":"FALSE"},0]
[null,null,null,null,null,null,{"$f":"E40","v":0}]
[null,"TOTAL MATERIALS & SUPPLIES ",null,null,{"$f":"IF(J25=\"No\",C41,0)","v":0},{"$f":"E41","v":0},{"$f":"E41","v":0}]
[null,null,null,null,null,{"$f":"E42","v":0},{"$f":"E42","v":0}]
[null,"TOTAL TRAVEL",null,null,{"$f":"IF(J26=\"No\",C43,0)","v":0},{"$f":"E43","v":0},{"$f":"E43","v":0}]
[null,"TOTAL OTHER COSTS:"]
[null,"Patient Care",null,null,{"$f":"IF(J27=\"No\",C45,0)","v":0},{"$f":"IF(J27=\"No\",C45,0)","v":0},{"$f":"E45","v":0}]
[null,"Rental Costs",null,null,0,{"$f":"IF(J28=\"No\",C46,0)","v":0},0]
[null,"Tuition",null,null,0,{"$f":"IF(J29=\"No\",C47,0)","v":0},0]
[null,"Scholarships/Fellowships",null,null,0,{"$f":"IF(J30=\"No\",C48,0)","v":0},0]
[null,"Participant Support Costs",null,null,0,{"$f":"IF(J31=\"No\",C49,0)","v":0},0]
[null,"All Other Direct Costs",null,null,0,{"$f":"E50","v":0},0]
[]
[null,"TOTAL INDIRECT COSTS",null,null,{"$f":"C52","v":0}]
[null,null,{"$f":"IF(C50<0,\"ERROR - Other ODCs should be positive (C25-C26-C27-C28-C29-C30)\",\" \")","v":" "}]
[null,"TOTAL DIRECT COSTS",{"$f":"SUM(C15:C17,C18,C41,C43:C44)","v":0},null,{"$f":"SUM(E15:E50)-E18","v":0},{"$f":"SUM(F15:F50)-F18","v":0},{"$f":"SUM(G15:G50)-G18","v":0}]
[null,"ALLOWABLE INDIRECT COSTS",{"$f":"D62","v":0}]
[null,"TOTAL BUDGET",{"$f":"SUM(C41,C43,C15:C18)+C44+C52","v":0}]
[]
[null,"CALCULATED BASE",{"$f":"C70","v":0},null,{"$f":"IF($C$12>0,$C$12*E54,0)","v":0},{"$f":"IF($C$12>0,$C$12*F54,0)","v":0},{"$f":"IF($C$12>0,$C$12*G54,0)","v":0}]
[]
[]
[]
[null,null,"Allowable Indirect",{"$f":"IF(J20=\"yes\",E57+E58,IF(J22=\"yes\",G57+G58,IF(J24=\"yes\",F57+F58,IF(J20=\"no\",E57+E58,IF(J22=\"no\",G57+G58,IF(J24=\"no\",F57+F58))))))","v":0}]
[null,null,"Budgeted Indirect",{"$f":"C52","v":0},"Based on the Base Exclusions Above:"]
[null,null,"Difference",{"$f":"D62-D63","v":0},{"$f":"IF(D64>0,\"Indirect is UNDER budgeted - No Change Required\",IF(D64<0,\"Indirect is OVER budgeted - Calculation Correction Required\",\" \"))","v":" "}]
[]
[]
[]
[null,"Applicant Indirect Calculation",null,"Budgeted","Calculated"]
[null,"(Back-In)","Base","Indirect Costs","Rate"]
[null,"If Using MTDC (Per NICRA Base)",{"$f":"IF(J24=\"yes\",F54, IF( J22=\"YES\", G54,E54))","v":0},{"$f":"C55","v":0},{"$f":"D70/C70","v":{"$error":"#DIV/0!"}},null,"Calculated Rate should reflect % in NICRA (C38)"]