Results 1 to 10 of 27

Hybrid View

  1. #1
    Player
    Forte's Avatar
    Join Date
    Dec 2011
    Posts
    139
    Character
    Solumbum Hircine
    World
    Sargatanas
    Main Class
    Summoner Lv 70
    Omg I wish my server did this o.0 thats find of awesome
    (0)

  2. #2
    Player
    Molly_Millions's Avatar
    Join Date
    Mar 2011
    Location
    Uldah
    Posts
    4,086
    Character
    Molly Millions
    World
    Balmung
    Main Class
    Marauder Lv 50
    Quote Originally Posted by Forte View Post
    Omg I wish my server did this o.0 thats find of awesome
    If you want to start this on your server, you can dl my spreadsheets from here. In the .zip, I've provided two spreadsheets. Mats.xls has all of the formulas needed to determine point values for donated mats (on the "member Donations Template"), Mats 2.xls does not have them. Mats 2.xls should be uploaded to google docs (the formulas were removed due to a limitation in google docs spreadsheets). Then every week, you'll need to have somebody update Mats.xls with donated mats, then copy the values from the Mats.xls (local copy) to the Mats 2 on google docs so that the donations are visible to the donators.

    You'll need to create a tab for each member of the craft fair. (copy and rename the member donation template tab.) then on the 'Member Point & Requests' tab, you need to change the formula in cell C2 (for example) to something like this: ='Adaulfo Krieger'!B$86 where Adaulfo Krieger is the exact same name as one of the member tabs. All participants should give a list of which items they want which will be displayed on the 'Member Point & Requests' tab. When an item is passed to one of the members, change the received column to 'yes' that corresponds to the member that received it. When you do that, the member's point totals will be updated. Distributing finished products according to who has accumulated the most points and wants the finished product will allow the finished products to be distributed as fairly as possible. The idea is to create some transparency into the process that determines who gets finished products.
    (0)