+ Reply to Thread
Results 1 to 5 of 5

How to create arts festival scoring sheet

  1. #1
    Registered User
    Join Date
    08-13-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    11

    Smile How to create arts festival scoring sheet

    Hi all

    this is a competition scoring sheet

    i want to add this automatically

    when i enter chest number then the name of winner and team name want to come automatically and the pointing also (see sample)

    point first 5 point second 3 third 1

    how to do this ??????



    each fist place will get 5 points (eg. chest no 403 Ajila got first place so 'church Anamara' got 5 points. the same competitions 'church Mesich' got second place so they got 3 points. member of 'Church Kalkadi' got third place so the 'Church Kalkadi' got 1 points. some times another church will get First place and Second place in same competition. If so the same church will get 8 points, that means the church will get 5+3 = 8 points. some times 10 Churches will come for the competition each church point calculation will consume more time. if i get it easy way that will be easy to me. please go through my sample file for getting details of competitions and point details.
    1. when I enter chest number other details (participants name and church name) want to come automatically
    2. points of each competition fill automatically 5,3,1 in respective church fields, and total
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: How to create arts festival scoring sheet

    Could you explain where you want the scores to automatically add up?

    Perhaps put a few examples in manually and reattach.

    BSB.

  3. #3
    Registered User
    Join Date
    08-13-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    11

    Re: How to create arts festival scoring sheet

    file with little more manual entries
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-13-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    11

    Re: How to create arts festival scoring sheet

    hi i have attached

  5. #5
    Registered User
    Join Date
    07-22-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    30

    Re: How to create arts festival scoring sheet

    Hi,

    I have done you (1) the Chest entry number that pulls in the correct Name and Team. Point (2) you are asking for is very time consuming to achieve in the worksheets current format.

    Hope this helps anyway,

    Tim
    Attached Files Attached Files

+ 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. Prepare automatic scoring sheet with pointing chart
    By stephensraj in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-19-2014, 03:06 PM
  2. Creating a scoring sheet for race series
    By rk97 in forum Excel General
    Replies: 1
    Last Post: 02-08-2014, 02:14 AM
  3. [SOLVED] Trying to Create a Template for Scoring a Test
    By fasterpie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2013, 01:20 PM
  4. Martial Arts Tournament Management
    By NRShukokai in forum Excel General
    Replies: 0
    Last Post: 01-24-2013, 10:31 PM
  5. Auto Scoring Sheet
    By Missile in forum Excel General
    Replies: 0
    Last Post: 04-20-2005, 06:06 PM

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