Review grant applications or make funding recommendations.

I need to circulate my grant-review spreadsheet to the panel by Wednesday. Confirm every application row has reviewer scores, letters of support linked, conflict declarations filled, and that the ranking tab recalculates in the order of weighted score before I share it with Dr. Alvarez and the selection committee.

Before I send this to the review panel, make it easy for them to decide: surface the composite score and funding recommendation in the leftmost columns, flag any application missing budget justification or institutional approval, collapse reviewer comments into a single summary cell, and mark the threshold candidates for discussion.

I finished entering scores but two reviewers rated the same proposal 2 and 9; the selection committee emailed asking for reconciliation and we meet Friday. I can’t tell if one reviewer used a different rubric, mis-clicked, or if there’s a data-entry error. What’s the most likely explanation and the fastest way to present a defensible note to the committee?

Every funding round we waste a day reconciling divergent reviewer scores because reviewers use ad hoc rubrics or enter scores into different tabs. Across six rounds the pattern is inconsistent score scales and missing justifications. Which concrete change should I make to the review workbook and reviewer instructions so panels stop getting stuck and decisions close two days earlier?