{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Combined"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Combined","index":0,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Title: "]
["PIs: list UWEC and Mayo"]
["Total Request: "]
["Project Period: "]
["RPI ID#: ",null,"Must be calendar years."]
[null,"Year 1","Year 2","Year 3","TOTALS","NOTES"]
["Salaries and Wages: Senior Personnel"]
["MAYO"]
[]
[]
["UWEC"]
["Name (time; 4% cost of living) ",{"$f":"SUM(62000/9)*1.04","v":7164.4444444444443},{"$f":"SUM(62000/9)*1.04*1.04","v":7451.0222222222228}]
[]
[]
[]
["Salaries and Wages: Other Personnel"]
["MAYO"]
[]
[]
["UWEC"]
["UWEC Undergraduates (5 hrs/wk x $12/hr x  15 wks Fall 2023 and 15 wks Spring 2024) ",{"$f":"SUM(12*5*15)*2","v":1800},{"$f":"SUM(12*5*15)*2","v":1800}]
[]
["Fringe Benefits",{"$nulls":4},"UWEC Fringe Benefits"]
["MAYO"]
[]
[]
["UWEC"]
["UWEC Faculty  @ 47%",{"$f":"SUM(B12*0.47)","v":3367.2888888888888},{"$f":"SUM(C12*0.47)","v":3501.9804444444444}]
["Undergrads  @ 2%         ",{"$f":"SUM(B21*0.02)","v":36},{"$f":"SUM(C21*0.02)","v":36}]
[]
["Materials and Supplies"]
["MAYO"]
[]
[]
[]
["UWEC"]
["  Inclinometers (cost per item, shipping) ",{"$f":"SUM(179*2)+(221*2)+40","v":840}]
[]
["Consultant/Contract"]
["MAYO"]
[]
[]
[]
["UWEC"]
[]
[]
["Travel"]
["MAYO"]
[]
[]
[]
["UWEC"]
[]
[]
[]
[]
[]
["MAYO - Total Direct Costs",{"$f":"SUM(B9:B10,B18:B19,B25:B26,B33:B35)","v":0},{"$f":"SUM(C9:C10,C18:C19,C25:C26,C33:C35)","v":0}]
["UWEC - Total Direct Costs",{"$f":"SUM(B12:B57)","v":13207.733333333334},{"$f":"SUM(C12:C57)","v":12789.002666666667}]
["MAYO - Indirect Costs @ 30% total direct costs",{"$nulls":4},"Policy Language for Mayo Indirect Costs (July 2023):  Consisting of all salaries and wages, fringe benefits, materials, supplies, services, travel and subgrants and subcontracts up to the first $25,000 of each subgrant or subcontract (regardless of the period covered by the subgrant or subcontract). Excludes equipment, capital expenditures, charges for patient care, student tuition remission, rental costs of off-site facilities, scholarships, and fellowships as well as the portion of each subgrant and subcontract in excess of $25,000. "]
["UWEC - Indirect Costs @ 41% salaries, wages, fringe",{"$f":"SUM(B12:B29)*0.41","v":5070.7706666666663},{"$f":"SUM(C12:C29)*0.41","v":5243.4910933333331}]
["MAYO - Total Request",{"$f":"SUM(B58+B60)","v":0},{"$f":"SUM(C58+C60)","v":0}]
["UWEC - Total Request",{"$f":"SUM(B59+B61)","v":18278.504000000001},{"$f":"SUM(C59+C61)","v":18032.493760000001}]
[]
["Updated: 5/16/2023"]
["Activity Code = Research (04)"]
["Mayo operates on a calendar year, January to December"]