Omg I wish my server did this o.0 thats find of awesome
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.
|
![]() |
![]() |
![]() |
|
Cookie Policy
This website uses cookies. If you do not wish us to set cookies on your device, please do not use the website. Please read the Square Enix cookies policy for more information. Your use of the website is also subject to the terms in the Square Enix website terms of use and privacy policy and by using the website you are accepting those terms. The Square Enix terms of use, privacy policy and cookies policy can also be found through links at the bottom of the page.