![elvenar gem factory elvenar gem factory](https://en.wiki.elvenar.com/images/c/c3/G_Elves_FactoryGems_31.png)
As far as I can tell, in at least some places, the lower level manufactories are so much more efficient than their larger counterparts, that using the same number of MMs in each scenario resulted in an almost equal production amount between the two manufactory sets, with a slight edge even going to the smaller manufactories occasionally. Since my main goal in putting this together was to see if, as I suspected, a larger number of low level manufactories could provide equal or greater production in the same space than a smaller number of large manufactories, I also played around with seeing what effect this might have on the use of MMs. To produce, say, 850 gems, will cost you almost exactly the same amount in coins and supplies whether you do it with one level 30 manufactory, or with 4 level 17s. Nowhere that I ran the numbers so far have I found that roads altered the balance of whether a given manufactory level was more or less productive than an equally producing number of lower manufactories, so I think the space-saving possibilities of lower manufactory levels as reflected in the spreadsheet is still accurate even when roads have been taken into account.ΔΆ) Supplies/Gold Required - The supplies or coins required seem to be almost even through all the levels of any given manufactory (e.g., production of 1 Gem in a Level 1 Manufactory requires 32 Supplies and 320 Gold, while production of 1 Gem in a Level 18 Manufactory requires 32.0087336 Supplies and 320.0087336 Gold, and production of 1 Gem in a Level 28 manufactory requires 31.2 Supplies and 312 Gold), so calculating the cost seemed unnecessary. I may eventually add a column, but for now they remain uncalculated. Accordingly, I have, for now, left these out of the equations as a confusing wildcard. To be accurate, calculating roads also requires working in whole buildings, which is not how the spreadsheet is currently set up. Things I left out on purpose: 1) Roads - the ratios of road/production I got doing these calculations seemed to vary greatly based on how many manufactories I dealt with and what chapter they were in. I did my best to ensure accuracy but with so much data to copy and collate, it seems almost inevitable that I will have made a mistake in data entry somewhere, so if you see any errors, please let me know so that I can update the sheets appropriately. If anyone has questions about the data or layout, I'll be happy to explain.
![elvenar gem factory elvenar gem factory](https://en.wiki.elvenar.com/images/4/48/EL_Humans_FactoryMetal_25.png)
The highest production values on each tab are highlighted so they can be seen at a glance. The manufactory levels that are available in a given chapter are in black text the levels that would not yet be available for upgrade are still included in a lighter grey text, in case anyone wants to make copies and play around with the formulas or numbers. At the end are tabs with the basic residence, culture, and manufactory numbers that I used for calculation. Then each tab after that runs the math for all manufactory levels with a focus on a particular chapter. As before, the first tab of each spreadsheet uses the appropriate chapter-specific numbers to demonstrate the efficiency of the usual path taken by players of updating all buildings to as high of a level as possible in each chapter. The cultural and residential numbers for the first five chapters are based on the old research tree (which the vast majority of players still have). These spreadsheets analyse the efficiency of each manufactory level in each chapter of the guest races, from Dwarves to Revenge of the Exile. Okay, I finally got all the manufactories finished and ready to share!