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.
Just stopping by to say that the first week after changing focus was very much a success! We'll see the first Mailbreaker get passed out in our group next week. (It's on my alt.) Thanks goes to everyone who donated mats, keep 'em coming!
Just an fyi, next week we need HQ gold nuggets and coke pretty badly. We also need some hq hypogryph skins. Also, I edited the 2nd post to keep it updated with the mats we need and other useful info.
Last edited by Molly_Millions; 06-19-2012 at 02:17 AM.
Hey Molly I need you to log onto your alt so I can give you some mats, I will be working this weekend Friday - Monday. I hate to miss the crafting fair! It is so awesome and so busy!
An idea to ponder. You know how with so many people in one spot you can't see everyone. Well, As this shell grow I am thinking if we split up via craft job and spread out a bit, this may relieve some of the congestion at the fountain. Just a thought, catch ya later!
Got 'em.
I had an idea about how to use some of this NQ darksteel ore we're gonna end up with too actually. I'm waiting for Jet to tell me if some things are possible with his bestiary first though. Maybe you can guess what I'm thinking of. :P
bumpity bump
It's time for another craft fair in a few hours. If you don't have a large LS, or are in an LS that is lacking crafters or gatherers, the craft fair is your chance to get the weapon you need for the relic quest or fill your other crafting needs. I'll be collecting donations on my alt, Tessier Ashpool, a bit early if you'd like to participate. This week we are especially in need of Trilluim +1, Trillium Bulb +1, Copper Ore +1, Gold Ore +1, and Coke.
bump.
It's almost that time again. We're still low on the same items as last week. (it was a slow week last week.) Also, just an FYI, I have 3 mailbreakers and a rampager to pass out. So if you don't yet have one, have signed up for one, and have been donating mats or time, you'll most likely be getting a mailbreaker today.
|
![]() |
![]() |
![]() |
|
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.