How To: organize your clan crafting

[kinngrimm]

If you want to make it database style, use the "Form" Option in google spreadsheats, that way your faction members can fill out the data themselves, but i am not sure about updating. As i see this as a really important information about my clan friends, this information is collected in our forums but then transfered by a few, which then have a good overview. I wouldn't want to have this information out of anybody i am a bit conservative that way 

If you want to go a step further try to combine this with your actual equipment list you would use to equip for battles.
For that you perhaps would need to read into the sql statements which can be used by google spreadsheats.

[Slamz]

Useful formulas I've added recently:

Personal troop upkeep:

=roundup((((F2^1.03) * 1.8) - 100) / 24)

(input the number of troops you have into "F2", in this case, and the formula tells you how much it costs per turn)

Fief troop upkeep:

=roundup((((F2^ 1.02) * 1) - 100)/24)


Number of troops per upkeep (input the upkeep you want to pay and it calculates max number of troops you should have)

Personal:

=rounddown((((J2 * 24) + 100) / 1.8)^(1/1.03))

Fief:

=rounddown(((J2 * 24) + 100)^(1/1.02))


Replace columns with whatever works for you, of course.

I recommend creating a separate tab for this stuff.


I *think* these are all correct.  That is, the formulas are from chadz post but the rounding is sort of an assumption.  50 troops actually comes out to like .05 upkeep or something but I think chadz rounds it up, so 50 troops = 1 upkeep (but you can actually have up to 60 troops and still only pay 1 upkeep.  At 61, it becomes 2 upkeep.)

[awesomeasaurus]

traitor.

[MrShine]

wait what is this goo-gul you speak of?

[arowaine]

HUEHUEHUE of course Arowaine already knows. Jesus people, you're all slow.

troll
ofcorse i know already and i have been using the google tool document 2 week afther strat 3 came out