{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Complexity Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Complexity Calculator","index":0,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Complexity Factors","Weight","Select Yes or No"]
["Mandatory Cost-Share",1]
["3rd Paty-Cost Share Provider",2]
["Voluntary Cost Share",2]
["1 Subrecipients / NSF Collabrative Partners",1]
["2 Subrecipients / NSF NSF Collabrative Partners",2]
["3-5 Subrecipients / NSF NSF Collabrative Partners",3]
["6+ Subrecipients / NSF NSF Collabrative Partners",4]
["UMass as Subrecipient / UMass as Non-Lead Collaborative Partner",0]
["UMass 1-2 PI/co-PI/Senior Personnel",0]
["UMass 3-5 PI/co-PI/Senior Personnel",1]
["UMass 6+ PI/co-PI/Senior Personnel",2]
["PI(s) over NIH Salary Cap (if applicable)",1]
["PI = New Faculty Member",1]
["Post Doc / GRA Fellowships Grant Proposals",1]
["Foreign / Small Business Subrecipient(s)",2]
["National Lab (FFRDC) Involvement",2]
["Foundation / Industry / State / Local Gov't",1]
["Standard NSF / NIH",0]
["DOI /  USDA  / NIFA / EPA / NASA",1]
["DOD / DOE / DOEd / DOT",2]
["DARPA / ARPA-H",3]
["NIH Multi-Project RFA (U01 / P01 / etc.)",11]
["Foreign Sponsors",2]
["Sponsor Portal",1]
["Sponsor Portal w/ MFA and no Admin access",2]
["Shortened or Irregular Budget Period(s) (< or > 12 months)",1]
["Non-Budgetary Administrative Forms ",1]
["Simple Budget Spreadsheet/Form",1]
["Complex Budget Spreadsheet/Form (Tasks, Hourly rate conversions, Milestones, etc.)",3]
["S2S",0]
["S2S with User Attached Forms",1]
["S2S with Manual R&R / SF 424 Forms",2]
["Intellectual Property (TTO)",1]
["Terms and Conditions to be reviewed/approved by OPAM/UMII",1]
["Animal/Human Subjects (IACUC/IRB)",1]
["Fabricated Equipment",2]
["IDC Variance required by sponsor",1]
["IDC Waiver Request",3]
["Hierarchy Budget",2]
["Total Weight"]
[]
[]
["Insert Prime Sponsor Deadline Below (MM/DD/YYYY)",null,"RDS Request Deadline"]
[{"$f":"TODAY()","v":"2025-07-11"},null,{"$f":"IF(AND(C41>=0,C41<6),A45-30,\"\")","v":"2025-06-11"},"30 Days","0 - 5 Points"]
[{"$f":"TODAY()","v":"2025-07-11"},null,{"$f":"IF(AND(C41>=6,C41<11),A45-45,\"\")","v":""},"45 Days","6 - 10 Points"]
[null,null,{"$f":"IF(AND(C41>=11,C41<15),A45-60,\"\")","v":""},"60 Days","11 - 15 Points"]
[null,null,{"$f":"IF(AND(C41>=15,C41<\"infinity\"),A45-90,\"\")","v":""},"90 Days","16+ Points (NIH Multi-Project Proposals)"]