research-skills

Analyze Syracuse University Office of Research data from three DataInsights dashboards (Sponsored Proposals, Award Details, Detailed Sponsored Expenditures). Handles Tableau Excel exports with merged cells requiring forward-fill. Covers proposal tracking, award amounts with supplements, expenditure analysis by fiscal year, PI/department/sponsor queries, direct vs indirect cost analysis, burn rate calculations, and cross-referencing with faculty and Chart of Accounts data. Does NOT include General Ledger (GL) transaction parsing. ALWAYS use this skill when the user mentions Office of Research data, sponsored research analysis, proposal tracking, award analysis, research expenditures, DataInsights dashboards, or provides Excel files with names like Proposal_Details, Award_Details, or Expenditure_Details.

Syracuse University OSP Budget Template population for sponsored research proposals. Use when PIs need to create, populate, or modify the OSP Budget Workbook (FY26) for federal or non-federal grants. Handles personnel (senior/other), non-personnel costs (equipment, travel, participant support, materials, consultants, subawards, tuition, human subjects), F&A rates, fringe rate lookups, and generates Excel workbooks. For DOE Genesis Mission proposals (DE-FOA-0003612), generates BOTH the SU OSP Budget Excel file AND the SF424 R&R Budget form. ALWAYS use this skill when the user mentions Genesis Mission, DOE Genesis, DE-FOA-0003612, SF424 R&R budget, or asks about building a budget for a DOE Genesis proposal. Self-contained — includes all rate data, policy references, calculation functions, and the SF424 R&R template with no external skill dependencies. Requires Claude Opus 4.5+ and the xlsx skill.