DeletedUser2870
Guest
I finally worked out kinks in the conditional formatting formulas in my FS sheet which has morphed from its humbler beginnings to include columns on factory numbers, sizes, and levels. However, those alone won't do. We also need to take into account boost percentages and production activity, i.e. doing how many of each prod-run type a day. For example, Marble should be our biggest concern right now since it has the lowest space and size out of all tiers but, since 3 Marble producers are very active, we're not feeling a shortage. Our Magic Dust on the other hand, used to have better numbers than Gems but the Gems producers (who are also the 3 Marble producers and I'm one of them) are also very active to the point that we have an excess of Gems even though Elixirs outnumbered us a lot before.
I wouldn't have had to add those extra columns if everyone entered their daily average output numbers because those are the most accurate figures but people were busy with the holidays and Flurry and are still recovering. I do find the extra columns useful though because they can help predict certain situations when output data is missing or not updated. Right now, I can see that cross-tier trading is inevitable because there's more space dedicated to Tier 3 factories than Tier 2 with Tier 1 close behind. It might be because some of our fellows are in the Orcs chapter which needs Tier 3 goods but, since I'm not yet in that chapter, I can't say for sure what the variables are and how to adjust ideal ratio calculations to account for guest race demands
Though I must congratulate you on an excelsheet that takes into account the number and lvl of specific factories of different pkayers, it still is only an indication.
A player with fewer, lower lvl factories may actually produce more because hes able to reset them every 3 hours while the other guy is using 9 hour resets. Or as in my case, because Im feeling screwed by the devs, often use 24 hour resets and dont play as much anymore.
;P you should add a column where you keep track of how many times a day they reset their factories...just a hint from a controlfreak...grins