+ Reply to Thread
Results 1 to 2 of 2

Evaluation form for several events - that sums / scores weighted answers by event

  1. #1
    Registered User
    Join Date
    06-20-2011
    Location
    Travelers Rest, SC
    MS-Off Ver
    Excel 2010
    Posts
    48

    Evaluation form for several events - that sums / scores weighted answers by event

    Is this possible? I would like to use jotform, surveymonkey or even Google Docs to build an evaluation form for events. Each question in the form would have a weighted value. If there are 100 events, ideally each event would have a total "score" so they could be ranked in order of highest score to lowest. I assume it would have to be an average score since some events may be reviewed by 2 people whereas others may be reviewed by 50.

    Thank you in advance.

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Evaluation form for several events - that sums / scores weighted answers by event

    you wont be able to do calculations from Google Docs because it is not a "form" application. However, this can easily be done by sending the response data from Google Forms to Google Sheets.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Weighted scores for student tasks
    By Redwrex in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2021, 11:55 PM
  2. [SOLVED] Redistributing weighted score total if multiple answers not given
    By route62us in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-13-2021, 08:24 PM
  3. [SOLVED] Creating an evaluation form to calculate 3 different scores in Excel
    By Serpan75 in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 07-13-2020, 04:42 AM
  4. [SOLVED] SOLVED - Averaging weighted scores without counting blanks
    By BamaRatt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2020, 02:00 PM
  5. Replies: 1
    Last Post: 02-28-2018, 02:38 AM
  6. [SOLVED] Formula to calculate supplier evaluation scores based on their profit margin %
    By The_Snook in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2015, 06:03 PM
  7. Weighted Scores
    By Ericen in forum Excel General
    Replies: 2
    Last Post: 01-02-2015, 12:18 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1