I apologize if this forum isn’t for novice advice
I am thinking my ability to clear this hurdle (if it can be cleared) will determine if Airtable is going to be a good choice for me.
I manage a grant process. The software that manages my process gives me reports that can be exported to excel and then csv.
**My goal - ** Create a base where I manage the grant processes. I have started with a table that has all the applicants listed and within that table a link to a table where I have four individual categories of grant applications - and each application is ONE of those categories and linked accordingly
Now when the grants are submitted, I have a team of 8 reviewers who score the applications (three evaluation peices - a score (numeric) a drop down (yes/no) question and a narrative field.
When I export the scores I get a spreadsheet that gives the score by reviewer. There is a row in the spreadsheet for every application with the scores of the eight reviewers. _Mind you, the likelihood of data getting mixed up and the human error factor - using a spreadsheet to analyze the data is torturous _
I don’t know anything about PIVOT tables - or if they even might be a spreadsheet help - but I was most excited about finding this product - hoping I could get a more reliable and analytic result with my data.
My confusion ratchets up when I think about how I accurately import various data and make sure it matches to the right record.
I had added a table where my reviewers are the record …
When I have the scores from the 8 reviewers in spreadsheet form, what (if any) is the best what to make sure the imported data associates the individuals scores for each proposal with the RIGHT proposal?
In my spreadsheet nightmare, I have to carefully cut and paste to make sure the program is lined up correctly with each reviewers score.
How do I get the data from the scoring spreadsheet to recognize (or match) to the right program?
Ultimately I want to create a table that will do the calculations to get the average scores for each program and then create a form where I can give the reviewers the results of the scoring (sorted by high to low) and show them what their score was.
Am I destined to Excel nightmares forever?