SPIE Chairs: Here’s Help Processing Your Reviewer Ratings

The Problem: You are a Chair for a SPIE conference, your review team has provided numerical ratings for all your oral and poster submissions, and now you have to sort through all the numbers and prepare a draft program.

The Solution: Use R!

1. Go into MySPIE into the “Review Presentations” section

2. Click on the Excel icon for “Reviewer Results” (with comments)

3. Save that file as a CSV into some directory on your machine. I saved mine to C:/SPIE12/PresRevs.csv

6. This will export two CSV files, one with all your processed reviews in order of the paper number, and the other in order of the highest ranked paper first.

7. Have fun preparing your program.

Note: If ANYONE uses this, let me know – would love to know that my solution for making my SPIE Chair life easier actually helped someone else too. Or, if you can think of improvements to make, I might be interested in coding those for future use too :) Leave a comment or send an email. Thanks.

I'm available for consulting and enjoy work that addresses strategic positioning that integrates quality and innovation -- just email me and let me know what's on your mind! If I can't do it, I'll refer you to someone trustworthy who can. 100% of the proceeds from my consulting support the Burning Mind Project.

I also enjoy references to quality in fiction & drama so let me know if you read any good quality-related novels, or watch any movies where quality and innovation play major roles.

Notice

You are free to reprint articles in part or in their entirely, for any purpose not for profit, as long as 1) this source and its authors are cited, 2) we are notified of the reprint and 3) we are provided with a copy or URL. Thank you!