RoughKnecS
--> Want art? <--
--> Or see Tadpole banners? <--
The industrys greats
** Cerberus ** Killah ** Shadowheart **
First post updated with link to latest version! :)
I think you forgot about Dryad's different off values for Horses/Prisoners/Mercs
Also, really not liking cells being locked!
Otherwise stellar job!
Last edited by djakdarippa; 04-11-2017 at 18:13.
Nope, it's in there. You have to add Stables and/or # of Mercs you're sending for it to actually show up in your offense. I did notice that the actual value for Dryad's horses was 3 instead of 4, and this has been corrected.
What's not to like about it? The green cells are the only ones that need to be edited, so it shouldn't be an issue.
Thanks :)
hey crystopher first off thanks for a great tool!
I found an issue where dryads do not have food produced by non farms being accounted for. think you can get that fixed up?
Thanks!
Thanks a ton for this Crystopher!
Looks like bocan offense and defense values are swapped. Has 4 as defense and 7 as offense.
Thanks! I've updated this on the sheet. Seeing it in raw numbers, that's a pretty significant boost there O.O
D'oh, I was afraid I did that with one of the races. It's due to the fact that the columns are displayed with defense before offense. I've fixed this and also swapped the columns so I don't do it in the future :P
Thanks for the feedback everyone :)
One more thing Crys,
Seems like sending one gen or 4 gens gets you the same off, is that ok or needs a tweek?
man i find that general calculation annoying on my sheet too! easier when no race has modified gens...
you should get a +0.03 OME, for each general above the original one to be sent, so 4 gens should be +0.09 OME as far as I know
Cool! Thx Chrystopher! Awesome work keeping this updated.
One thing though, I'm not sure I like protecting the sheet. For the reason of someone not messing up formulas by mistake I get it. But I didn't release it to the public to have it protected. I think its nice if people want to modify it to their own needs/try change or optimise the formulas... freedom of information and creativity and all. The problem of people stealing and passing it off as their own should be rather minimal in this environment anyhow...
Hmm, yea. Something seems off with the "off" formula with regards to generals. It does add off sending more, but only a tiny bit. I haven't looked at the formula though. I'm sure Chrystopher will find whats wrong :)
RoughKnecS
--> Want art? <--
--> Or see Tadpole banners? <--
The industrys greats
** Cerberus ** Killah ** Shadowheart **
EDIT: The issue with the generals has been fixed! The problem was with the formula being multiplied by zero if there were no Stables/Dungeons added. This was fixed by moving the generals calculation from Mod Offense to OME (which, incidentally, is where it belongs). Let me know if there's anything else I've missed :)
HM, I just reviewed the formula and it's present there, but you're right that it's not contributing for some reason. I'll give it an in-depth look and have it fixed ASAP.
Can't argue with that, very valid points. The current version shouldn't have any protection, but I'll double-check it just to be sure.
Last edited by Crystopher; 06-11-2017 at 23:40. Reason: Fixed generals bug
Coolio.
Dryad food production from acres is apparently enhanced by production sci. Don't think the sheet takes that into consideration...
RoughKnecS
--> Want art? <--
--> Or see Tadpole banners? <--
The industrys greats
** Cerberus ** Killah ** Shadowheart **
There are currently 2 users browsing this thread. (0 members and 2 guests)