Where do I pull the Jury Votes & How to create report?

Steps to export voting report data in Dashboard:

  • Look for the menu item “NGG Voting” and the sub menu item “Top Voted” and click it.
  • At the top of this page is a form where you can input the search variables.
  • Set “0” for the limit (this will give you all results)
  • Put in the date range that you need and pull both an “Average” and a “Individual Votes” report by toggling and click “Export Results” twice

Combine the two reports into one Excel xls file with each on their own tab. The average vote tab will need to be paired with the final list of applicable artists spreadsheet since the artist name will not appear anywhere on this report. Only the CAF ID will appear via the file name, so it will need to be cross referenced with the final artist report from GravityForms. The voting reports spreadsheet will be organized by highest to lowest votes so change sort to Gallery Name and then Filename. 

Steps to marry the artist anonymized ID # with voting average report tab:

  • In final artists app report (sorted by media category, then anon ID #), select just the Your Anonymized ID column, copy and paste into blank Word doc
  • Select table, go to Table > Insert Columns to the Right twice so there are now 3 columns total with right two being blank
  • Select table, go to Table > Convert Table to Text
  • Select Paragraph marks in “Separate text with” list, hit OK
  • Select table again, go to Table > Convert Text to Table
  • Leave defaults which should show Separate text at Paragraphs, hit OK
  • Select table and copy data
  • Go to voting spreadsheet, insert new column to the left of Gallery Name, paste Your Anonymized ID column data from Word doc
  • Repeat above steps with Business Name column from artists app report inserted as first column

Steps to create final Jury Voting Report with averaged scores and rankings:

  • Move pid and Criteria columns after last column of data
  • Create average scores for all 3 artist image submissions by inserting column to left of Avg / 10 column and use Excel formula =SUM(H2:H4)/3 on just the rows with anon ID rows
  • Create a copy of average tab (NextGEN Votes) and name tab Biz Name
  • Copy ALL Avg / 10 column data and “Paste Special” with Values selected
  • Delete Filename, Avg / 10, Min / 10, Max / 10, Number Votes, Image URL, pid and Criteria columns
  • Insert column to right of Business Name named Rankings (centered text with number styling in 4 digits 00.00)
  • Add Excel formula =F2*10 on just the rows with ALL Avg / 10 column data
  • Select all tab data and sort by Rankings column (order Largest to Smallest)
  • Delete rows at bottom with only Media Category
  • Select all tab data and sort by Business Name column & then Media Category
  • Save file as Jury Votes Total_YEAR CAF.xls

Posted in: Site Maintenance FAQs