|
Post by zepp on Feb 24, 2015 14:37:34 GMT -8
|
|
aris
New Member
Posts: 27
|
Post by aris on Feb 24, 2015 23:31:55 GMT -8
i was wondering about "required" : are you counting in also the mats required for upper class items? if yes, i think that it is confusing when one prioritize the building mats processing .. take as example Siege works : i see that there are 351 ladders required so i will build ladders without end (i can login 2-3 min every 1-2 hours so that means i have max 8 logins per day - 8 ladders/day) that would have the result that maybe we will have surplus of ladders and big lack of higher mats... if the actual numbers are in than one can split his contribution and participate to the common effort with a part of each mat.
Also, i would prefer the unified format where all data is in there and we can make decisions based on info from spreadsheet.
|
|
|
Post by zepp on Feb 25, 2015 1:32:04 GMT -8
The left column is the total mats needed, the right (brown) column is the required amount for donation. The amount from higher level items is automatically deducted when higher level items are crafted.
I just noticed that there appear to be some glitches in the formulas for the unified format. I am thinking that it is the way to go as it makes inputting data easier.
|
|
aris
New Member
Posts: 27
|
Post by aris on Feb 25, 2015 2:06:03 GMT -8
ok, thanks for explanation! then i will look only to the brown column Should i understand that if in required (brown) column the font is black than the requirements are fulfilled? Also, the same thing when the font in my column is black? Thanks!
|
|
|
Post by zepp on Feb 25, 2015 5:14:33 GMT -8
Yes, however, the sheet is only currently set for one Aid camp. If we add camps the requirements will adjust.
Edit: I fixed the problem with the number of required items not being calculated correctly. Everything should work fine now. Also, I have set current priorities for several buildings on the far left. Bright yellow is top priority, moderate yellow secondary, and dull yellow tertiary.
|
|
aris
New Member
Posts: 27
|
Post by aris on Feb 25, 2015 6:00:55 GMT -8
Wow, great work o Master of Sheets!!!
|
|
|
Post by tremond on Feb 25, 2015 15:42:20 GMT -8
Not sure what thread to put this post in… but I figured putting it here will be seen... I'm still logging in fairly often every day at the moment… but mainly to send out my Adventure party and keep the production line rolling. So I log in and 5 minutes later I log out. This is because I'm pretty busy with work for about the next week or so. I'll be back with a bit more of a presence after that. Going to check to see dates on next AvA which will be our 'on' cycle. So I'll probably have a lot of stockpiles and coin/CP for that one. After that I'll start my RI cycle. Should have done it starting a couple weeks ago but I wasn't ready so I'll do it after our next AvA on cycle. Just figured I'd let you know I'm still around even if you don't see/hear from me for the next bit. Tremond
|
|