"Total raw" calculation

DaveMcW · Post by **DaveMcW** » Tue Jun 17, 2014 8:23 pm

The raw resources calculation is inconsistent between buildings. I think it should always show the base resources (iron ore, copper ore, coal, oil, water, wood, alien artifact) wherever it is viewed.

Chemical Plant:
Note that the heavy oil icon is used instead of oil.

: chemical_plant.jpg (41.59 KiB) Viewed 47262 times

Assembler 2:

: assembler2.jpg (28.79 KiB) Viewed 47262 times

Assembler 1:

: assembler1.jpg (38.47 KiB) Viewed 47262 times

Post by **slpwnd** » Wed Jun 18, 2014 8:10 am

This is not a bug. This is an intended behavior. It always shows the "lowest recipes" in the tree that this machine can craft. So the assembling machine doesn't know how to craft the battery, therefore the battery is "raw" resource for the assembling machine.

I am moving this to ideas & suggestions. If this is annoying to many people we can think about changing this. Though there are some tricky subtle technical issues with this

Post by **ssilk** » Wed Jun 18, 2014 8:41 am

I think we need both info: the gross and the net calculations (in German and many other languages "brutto" and "netto"). I suggest a tab with the current as default.

http://en.wikipedia.org/wiki/Gross_(economics)
http://en.wikipedia.org/wiki/Net_%28economics%29
http://en.wikipedia.org/wiki/Netto

DaveMcW · Post by **DaveMcW** » Wed Jun 18, 2014 9:06 am

The current is almost useless. Maybe it is nice to see for manual crafting. But when I pick a recipe in an assembler I can only use the main ingredients. I don't care where the ingredients are made, it is just as easy to build another assembler or chemical plant.

I can see how there would be a problem picking between multiple recipes. There are 3 gas recipes (basic-oil-processing, advanced-oil-processing, light-oil-cracking). And an infinite loop with crude oil barrels. So you would need a variable to identify which should or should not be used.

I would say use basic-oil-processing for all 3 refinery products. It will give you the maximum crude oil needed, and players can decide whether to use advanced oil processing to reduce that number. Just like they can use productivity modules to reduce all numbers.

DaveMcW · Post by **DaveMcW** » Wed Jun 18, 2014 2:50 pm

I wrote a lua script to do it.

Lua Script

Code: Select all

package.path = package.path .. ';data/core/lualib/?.lua;data/base/?.lua'
require "dataloader"
require "data.base.data" 

data.raw.recipe["empty-crude-oil-barrel"].hidden_from_recipe_tree = true;
data.raw.recipe["advanced-oil-processing"].hidden_from_recipe_tree = true;
data.raw.recipe["heavy-oil-cracking"].hidden_from_recipe_tree = true;
data.raw.recipe["light-oil-cracking"].hidden_from_recipe_tree = true;

function getRecipe(item)
	local count = 1
	for i,recipe in pairs(data.raw.recipe) do
		if (recipe.results) then
			for j,product in pairs(recipe.results) do
				if (product.name == item) then 
					if (not recipe.hidden_from_recipe_tree) then
						return recipe
					end
				end
			end
		end

		if (recipe.result == item) then
			if (not recipe.hidden_from_recipe_tree) then
				return recipe
			end
		end
	end
	
	return nil
end

function getIngredients(recipe)
	local ingredients = {}
	for i,ingredient in pairs(recipe.ingredients) do
		local name, amount = 0
		if (ingredient.type) then
			name = ingredient.name
			amount = ingredient.amount
		elseif (ingredient[1] and ingredient[2]) then
			name = ingredient[1]
			amount = ingredient[2]
		end
		if (amount > 0) then
			local subrecipe = getRecipe(name)
			local multiple = 1;
				if (subrecipe and subrecipe.results) then
					for j,product in pairs(subrecipe.results) do
						if (product.name == name) then 
							multiple = product.amount
						end
					end
				elseif (subrecipe and subrecipe.result == name and subrecipe.result_count) then
					multiple = subrecipe.result_count
				end

			if (subrecipe == nil) then 
				ingredients[name] = amount / multiple
			else
				for subname,subamount in pairs(getIngredients(subrecipe)) do
					if (ingredients[subname]) then
						ingredients[subname] = ingredients[subname] + subamount * amount / multiple
					else 
						ingredients[subname] = subamount * amount / multiple
					end
				end
			end
		end				
	end

	return ingredients	
end

function round(num, idp)
  return tonumber(string.format("%." .. (idp or 0) .. "f", num))
end
	
for k,recipe in pairs(data.raw.recipe) do
	print(k)
	local ingredients = getIngredients(recipe)
	for name,amount in pairs(ingredients) do
		print(round(amount, 1) .. "x " .. name)
	end
	print ""
end

Output

Post by **ssilk** » Wed Jun 18, 2014 6:28 pm

I like those very praxis-orientated stuff.

DerivePi · Post by **DerivePi** » Fri Jun 27, 2014 6:40 pm

DaveMcW - I believe your crude oil numbers are a bit high. I also think that crude becomes problematic because you have two ways to produce it. For instance, if I need 2 units of lubrication for an electric engine unit, that can be considered 2 units of crude under basic refinery (10 crude in and 3 heavy, 3 light and 4 petro out) or 1.8 units of crude under advanced refinery (10 units of crude produce 11 items of Heavy, Light and Petro - 1, 4.5, 5.5).

I discovered the discrepancy because I can't find the published formula for the Electric Engine Unit. I'm getting 2 Lub, 1 engine unit and 2 ckts?

DaveMcW · Post by **DaveMcW** » Sat Jun 28, 2014 6:01 pm

I think you're right. It's better to assume all refinery products are equally valuable, instead of only looking at a single product. If people use cracking the crude oil costs might be off by 20%, but that's closer than being off by 200% like I was.

I played around with the script some more, and managed to eliminate the hidden_from_recipe_tree variable. It now avoids infinite loops on its own, and picks the cheapest recipe. This should allow it to handle any new recipe with no effort on the part of the modder.

In practical terms, this means:
empty-crude-oil-barrel: ignored because of infinite loop
heavy-oil-cracking: ignored because basic-oil-processing is cheaper
light-oil-cracking: ignored because basic-oil-processing is cheaper
advanced-oil-processing: ignored because (10 crude)/10 is cheaper than (10 crude + 5 water)/11

You could argue that 1 oil is more valuable than 5 water, but we would need a custom database entry to teach the game that.

Lua Script

Code: Select all

package.path = package.path .. ';data/core/lualib/?.lua;data/base/?.lua'
require "dataloader"
require "data.base.data" 

function getIngredients(recipe)
	local ingredients = {}
	for i,ingredient in pairs(recipe.ingredients) do
		if (ingredient.name and ingredient.amount) then
			ingredients[ingredient.name] = ingredient.amount
		elseif (ingredient[1] and ingredient[2]) then
			ingredients[ingredient[1]] = ingredient[2]
		end
	end
	return ingredients
end

function getProducts(recipe)
	local products = {}
	if (recipe.results) then
		for i,product in pairs(recipe.results) do
			if (product.name and product.amount) then
				products[product.name] = product.amount
			end
		end
	elseif (recipe.result) then
		local amount = 1
		if (recipe.result_count) then
			amount = recipe.result_count
		end
		products[recipe.result] = amount
	end
	return products
end

function getRecipes(item)
	local recipes = {}
	for i,recipe in pairs(data.raw.recipe) do
		local products = getProducts(recipe)
		for product,amount in pairs(products) do
			if (product == item) then
				table.insert(recipes, recipe)
			end
		end
	end
	return recipes
end

function getRawIngredients(recipe, exclude)
	local raw_ingredients = {}
	for name,amount in pairs(getIngredients(recipe)) do
		-- Do not use an item as its own ingredient 
		if (exclude[name]) then
			return {ERROR_INFINITE_LOOP = name}
		end
		local excluded_ingredients = {[name] = true}
		for k,v in pairs(exclude) do
			excluded_ingredients[k] = true
		end

		-- Recursively find the sub-ingredients for each ingredient
		-- There might be more than one recipe to choose from
		local subrecipes = {}
		local loop_error = nil
		for i,subrecipe in pairs(getRecipes(name)) do
			local subingredients = getRawIngredients(subrecipe, excluded_ingredients)
			if (subingredients.ERROR_INFINITE_LOOP) then
				loop_error = subingredients.ERROR_INFINITE_LOOP
			else
				local value = 0
				for subproduct,subamount in pairs(getProducts(subrecipe)) do
					value = value + subamount
				end

				local divisor = 0
				for subingredient,subamount in pairs(subingredients) do
					divisor = divisor + subamount
				end

				if (divisor == 0) then divisor = 1 end

				table.insert(subrecipes, {recipe = subrecipe, ingredients = subingredients, value = value / divisor})
			end
		end
		
		if (#subrecipes == 0) then
			if (loop_error and loop_error ~= name) then
				-- This branch of the recipe tree is invalid
				return {ERROR_INFINITE_LOOP = loop_error}
			else
				-- This is a raw resource
				if (raw_ingredients[name]) then
					raw_ingredients[name] = raw_ingredients[name] + amount
				else 
					raw_ingredients[name] = amount
				end
			end
		else
			-- Pick the cheapest recipe
			local best_recipe = nil
			local best_value = 0
			for i,subrecipe in pairs(subrecipes) do
				if (best_value < subrecipe.value) then
					best_value = subrecipe.value
					best_recipe = subrecipe
				end
			end

			local multiple = 0
			for subname,subamount in pairs(getProducts(best_recipe.recipe)) do
				multiple = multiple + subamount
			end

			for subname,subamount in pairs(best_recipe.ingredients) do
				if (raw_ingredients[subname]) then
					raw_ingredients[subname] = raw_ingredients[subname] + amount * subamount / multiple
				else
					raw_ingredients[subname] = amount * subamount / multiple
				end
			end 
		end
	end

	return raw_ingredients	
end

function round(num, idp)
  return tonumber(string.format("%." .. (idp or 0) .. "f", num))
end

for recipename,recipe in pairs(data.raw.recipe) do
	local exclude = {}
	for product,amount in pairs(getProducts(recipe)) do
		exclude[product] = true
	end
	local ingredients = getRawIngredients(recipe, exclude)
	if (ingredients.ERROR_INFINITE_LOOP) then
		ingredients = getIngredients(recipe)
	end
	print("[u]" .. recipename .. "[/u]")
	for name,amount in pairs(ingredients) do
		print(round(amount, 1) .. "x " .. name)
	end
	print ""
end

Output

ownlyme · Post by **ownlyme** » Mon Apr 15, 2019 4:41 pm

Brilliant script, thank you!
works ingame too, and i added a "time" entry in the return table, which should be 100% correct
call it by rawingredients(recipe)
when you call it on "nuclear fuel reprocessing" it returns the entry ERROR_INFINITE_LOOP = "used-up-uranium-fuel-cell", otherwise it works like a charm

Code: Select all

local exclude = {
["used-up-uranium-fuel-cell"] = true,
}
function rawingredients(recipe)
ret = getRawIngredients(recipe,exclude)
ret.time = (ret.time or 0)+recipe.energy
return ret
end

function getIngredients(recipe)
	local ingredients = {}
	for i,ingredient in pairs(recipe.ingredients) do
		if (ingredient.name and ingredient.amount) then
			ingredients[ingredient.name] = ingredient.amount
		elseif (ingredient[1] and ingredient[2]) then
			ingredients[ingredient[1]] = ingredient[2]
		end
	end
	return ingredients
end

function getProducts(recipe)
	local products = {}
	if (recipe.products) then
		for i,product in pairs(recipe.products) do
			if (product.name and product.amount) then
				products[product.name] = product.amount
			end
		end
	elseif (recipe.products) then
		local amount = 1
		if (recipe.result_count) then
			amount = recipe.result_count
		end
		products[recipe.products] = amount
	end
	return products
end

function getRecipes(item)
	local recipes = {}
	for i,recipe in pairs(game.recipe_prototypes) do
		local products = getProducts(recipe)
		for product,amount in pairs(products) do
			if (product == item) then
				table.insert(recipes, recipe)
			end
		end
	end
	return recipes
end

function getRawIngredients(recipe,excluded)
	local raw_ingredients = {
	["time"] = 0,}
	for name,amount in pairs(getIngredients(recipe)) do
		-- Do not use an item as its own ingredient 
		if (excluded[name]) then
			return {ERROR_INFINITE_LOOP = name}
		end
		local excluded_ingredients = {[name] = true}
		for k,v in pairs(excluded) do
			excluded_ingredients[k] = true
		end

		-- Recursively find the sub-ingredients for each ingredient
		-- There might be more than one recipe to choose from
		local subrecipes = {}
		local loop_error = nil
		for i,subrecipe in pairs(getRecipes(name)) do
			local subingredients = getRawIngredients(subrecipe, excluded_ingredients)
			if (subingredients.ERROR_INFINITE_LOOP) then
				loop_error = subingredients.ERROR_INFINITE_LOOP
			else
				local value = 0
				for subproduct,subamount in pairs(getProducts(subrecipe)) do
					value = value + subamount
				end

				local divisor = 0
				for subingredient,subamount in pairs(subingredients) do
					divisor = divisor + subamount
				end

				if (divisor == 0) then divisor = 1 end

				table.insert(subrecipes, {recipe = subrecipe, ingredients = subingredients, value = value / divisor})
			end
		end
		
		if (#subrecipes == 0) then
			if (loop_error and loop_error ~= name) then
				-- This branch of the recipe tree is invalid
				return {ERROR_INFINITE_LOOP = loop_error}
			else
				-- This is a raw resource
				if (raw_ingredients[name]) then
					raw_ingredients[name] = raw_ingredients[name] + amount
				else 
					raw_ingredients[name] = amount
				end
				
			end
		else
			-- Pick the cheapest recipe
			local best_recipe = nil
			local best_value = 0
			for i,subrecipe in pairs(subrecipes) do
				if (best_value < subrecipe.value) then
					best_value = subrecipe.value
					best_recipe = subrecipe
				end
			end

			local multiple = 0
			for subname,subamount in pairs(getProducts(best_recipe.recipe)) do
				multiple = multiple + subamount
			end

			for subname,subamount in pairs(best_recipe.ingredients) do
				if (raw_ingredients[subname]) then
					raw_ingredients[subname] = raw_ingredients[subname] + amount * subamount / multiple
				else
					raw_ingredients[subname] = amount * subamount / multiple
				end
			end 
			raw_ingredients["time"] = raw_ingredients["time"] + (best_recipe.recipe.energy or 1)*amount/multiple
		end
	end

	return raw_ingredients	
end

Edit: NEW VERSION!
- Now calculates the time based on the most energy-efficient crafting machine
- Also provides information about the energy required
- Breaks down liquids into crude oil
- Takes into account probabilities of products (doesn't work well with covarex enrichment process - so 1 fuel cell will cost 200 uranium ore)

Code: Select all

exclude = {
["used-up-uranium-fuel-cell"] = true,
}
function rawingredients(recipe) -- call this function
	if not global.best_machine then
		global.best_machine = {}
		for name, proto in pairs(game.entity_prototypes) do
			if proto.crafting_categories and proto.name ~= "player" and proto.name ~= "escape-pod-assembler" and proto.energy_usage and proto.energy_usage > 0 then
				for cat, _ in pairs(proto.crafting_categories) do
					if not global.best_machine[cat] then
						global.best_machine[cat]={speed = proto.crafting_speed or 1, energy = (proto.energy_usage or 1), name = name}
					elseif (proto.crafting_speed or 1)/(proto.energy_usage or 1) > global.best_machine[cat].speed / global.best_machine[cat].energy then
						global.best_machine[cat]={speed = proto.crafting_speed or 1, energy = (proto.energy_usage or 1), name = name}
					end
				end
			end
		end
	end
	ret = getRawIngredients(recipe,exclude)
	ret.time = (ret.time or 0)+(recipe.energy or 1)/global.best_machine[recipe.category].speed
	--ret.time = (ret.time or 0)+(recipe.energy or 1)
	ret.energy = (ret.energy or 0)+(recipe.energy or 1)/global.best_machine[recipe.category].speed*global.best_machine[recipe.category].energy
	return ret
end

function getIngredients(recipe)
	local ingredients = {}
	for i,ingredient in pairs(recipe.ingredients) do
		if (ingredient.name and ingredient.amount) then
			ingredients[ingredient.name] = ingredient.amount
		elseif (ingredient[1] and ingredient[2]) then
			ingredients[ingredient[1]] = ingredient[2]
		end
	end
	return ingredients
end

function getProducts(recipe)
	local products = {}
	if (recipe.products) then
		for i,product in pairs(recipe.products) do
			if (product.name and product.amount) then
				products[product.name] = product.amount
			elseif product.amount_min and product.amount_max then
				products[product.name] =  (product.amount_min+product.amount_max)/2 * (product.probability or 1)
			end
		end
	end
	return products
end

function getRecipes(item)
	local recipes = {}
	for i,recipe in pairs(game.recipe_prototypes) do
		if i ~="coal-liquefaction" and not (string.sub(item,-7) ~= "-barrel" and string.sub(i,-7) == "-barrel" and (string.sub(i,1,5) == "fill-" or string.sub(i,1,6) == "empty-")) then
			local products = getProducts(recipe)
			for product,amount in pairs(products) do
				if (product == item) then
					table.insert(recipes, recipe)
				end
			end
		end
	end
	return recipes
end

function getRawIngredients(recipe,excluded)
	local raw_ingredients = {
	["time"] = 0,
	["energy"] = 0}
	for name,amount in pairs(getIngredients(recipe)) do
		-- Do not use an item as its own ingredient 
		if (excluded[name]) then
			return {ERROR_INFINITE_LOOP = name}
		end
		local excluded_ingredients = {[name] = true}
		for k,v in pairs(excluded) do
			excluded_ingredients[k] = true
		end

		-- Recursively find the sub-ingredients for each ingredient
		-- There might be more than one recipe to choose from
		local subrecipes = {}
		local loop_error = nil
		for i,subrecipe in pairs(getRecipes(name)) do
			local subingredients = getRawIngredients(subrecipe, excluded_ingredients)
			if (subingredients.ERROR_INFINITE_LOOP) then
				loop_error = subingredients.ERROR_INFINITE_LOOP
			else
				local value = 0
				for subproduct,subamount in pairs(getProducts(subrecipe)) do
					value = value + subamount
				end

				local divisor = 0
				for subingredient,subamount in pairs(subingredients) do
					if subingredient ~= "intermediates" then
						divisor = divisor + subamount
					end
				end

				if (divisor == 0) then divisor = 1 end

				table.insert(subrecipes, {recipe = subrecipe, ingredients = subingredients, value = value / divisor})
			end
		end
		
		if (#subrecipes == 0) then
			if (loop_error and loop_error ~= name) then
				-- This branch of the recipe tree is invalid
				return {ERROR_INFINITE_LOOP = loop_error}
			else
				-- This is a raw resource
				if (raw_ingredients[name]) then
					raw_ingredients[name] = raw_ingredients[name] + amount
				else 
					raw_ingredients[name] = amount
				end
				
			end
		else
			-- Pick the cheapest recipe
			local best_recipe = nil
			local best_value = 0
			for i,subrecipe in pairs(subrecipes) do
				if (best_value < subrecipe.value) then
					best_value = subrecipe.value
					best_recipe = subrecipe
				end
			end

			local multiple = 0
			for subname,subamount in pairs(getProducts(best_recipe.recipe)) do
				multiple = multiple + subamount
			end

			if not raw_ingredients["intermediates"] then raw_ingredients["intermediates"] = {} end
			for subname,subamount in pairs(best_recipe.ingredients) do
				if subname == "intermediates" then
					for a, b in pairs(subamount) do
						raw_ingredients["intermediates"][a] = (raw_ingredients["intermediates"][a] or 0)+b*amount/multiple
					end
				elseif (raw_ingredients[subname]) then
					raw_ingredients[subname] = raw_ingredients[subname] + amount * subamount / multiple
				else
					raw_ingredients[subname] = amount * subamount / multiple
				end
			end 
			for a, b in pairs(getProducts(best_recipe.recipe)) do
				raw_ingredients["intermediates"][a] = (raw_ingredients["intermediates"][a] or 0)+b*amount/multiple
			end
			raw_ingredients["time"] = raw_ingredients["time"] + (best_recipe.recipe.energy or 1)/global.best_machine[best_recipe.recipe.category].speed*amount/multiple
			--raw_ingredients["time"] = raw_ingredients["time"] + (best_recipe.recipe.energy or 1)*amount/multiple
			raw_ingredients["energy"] = raw_ingredients["energy"] + (best_recipe.recipe.energy or 1)/global.best_machine[best_recipe.recipe.category].speed*global.best_machine[best_recipe.recipe.category].energy*amount/multiple
			
		end
	end

	return raw_ingredients	
end

mdemp · Post by **mdemp** » Fri Aug 14, 2020 12:10 am

ownlyme wrote: ↑Mon Apr 15, 2019 4:41 pm Brilliant script, thank you!
works ingame too, and i added a "time" entry in the return table, which should be 100% correct
call it by rawingredients(recipe)
when you call it on "nuclear fuel reprocessing" it returns the entry ERROR_INFINITE_LOOP = "used-up-uranium-fuel-cell", otherwise it works like a charm

Code: Select all

local exclude = {
["used-up-uranium-fuel-cell"] = true,
}
function rawingredients(recipe)
ret = getRawIngredients(recipe,exclude)
ret.time = (ret.time or 0)+recipe.energy
return ret
end

function getIngredients(recipe)
	local ingredients = {}
	for i,ingredient in pairs(recipe.ingredients) do
		if (ingredient.name and ingredient.amount) then
			ingredients[ingredient.name] = ingredient.amount
		elseif (ingredient[1] and ingredient[2]) then
			ingredients[ingredient[1]] = ingredient[2]
		end
	end
	return ingredients
end

function getProducts(recipe)
	local products = {}
	if (recipe.products) then
		for i,product in pairs(recipe.products) do
			if (product.name and product.amount) then
				products[product.name] = product.amount
			end
		end
	elseif (recipe.products) then
		local amount = 1
		if (recipe.result_count) then
			amount = recipe.result_count
		end
		products[recipe.products] = amount
	end
	return products
end

function getRecipes(item)
	local recipes = {}
	for i,recipe in pairs(game.recipe_prototypes) do
		local products = getProducts(recipe)
		for product,amount in pairs(products) do
			if (product == item) then
				table.insert(recipes, recipe)
			end
		end
	end
	return recipes
end

function getRawIngredients(recipe,excluded)
	local raw_ingredients = {
	["time"] = 0,}
	for name,amount in pairs(getIngredients(recipe)) do
		-- Do not use an item as its own ingredient 
		if (excluded[name]) then
			return {ERROR_INFINITE_LOOP = name}
		end
		local excluded_ingredients = {[name] = true}
		for k,v in pairs(excluded) do
			excluded_ingredients[k] = true
		end

		-- Recursively find the sub-ingredients for each ingredient
		-- There might be more than one recipe to choose from
		local subrecipes = {}
		local loop_error = nil
		for i,subrecipe in pairs(getRecipes(name)) do
			local subingredients = getRawIngredients(subrecipe, excluded_ingredients)
			if (subingredients.ERROR_INFINITE_LOOP) then
				loop_error = subingredients.ERROR_INFINITE_LOOP
			else
				local value = 0
				for subproduct,subamount in pairs(getProducts(subrecipe)) do
					value = value + subamount
				end

				local divisor = 0
				for subingredient,subamount in pairs(subingredients) do
					divisor = divisor + subamount
				end

				if (divisor == 0) then divisor = 1 end

				table.insert(subrecipes, {recipe = subrecipe, ingredients = subingredients, value = value / divisor})
			end
		end
		
		if (#subrecipes == 0) then
			if (loop_error and loop_error ~= name) then
				-- This branch of the recipe tree is invalid
				return {ERROR_INFINITE_LOOP = loop_error}
			else
				-- This is a raw resource
				if (raw_ingredients[name]) then
					raw_ingredients[name] = raw_ingredients[name] + amount
				else 
					raw_ingredients[name] = amount
				end
				
			end
		else
			-- Pick the cheapest recipe
			local best_recipe = nil
			local best_value = 0
			for i,subrecipe in pairs(subrecipes) do
				if (best_value < subrecipe.value) then
					best_value = subrecipe.value
					best_recipe = subrecipe
				end
			end

			local multiple = 0
			for subname,subamount in pairs(getProducts(best_recipe.recipe)) do
				multiple = multiple + subamount
			end

			for subname,subamount in pairs(best_recipe.ingredients) do
				if (raw_ingredients[subname]) then
					raw_ingredients[subname] = raw_ingredients[subname] + amount * subamount / multiple
				else
					raw_ingredients[subname] = amount * subamount / multiple
				end
			end 
			raw_ingredients["time"] = raw_ingredients["time"] + (best_recipe.recipe.energy or 1)*amount/multiple
		end
	end

	return raw_ingredients	
end

Edit: NEW VERSION!
- Now calculates the time based on the most energy-efficient crafting machine
- Also provides information about the energy required
- Breaks down liquids into crude oil
- Takes into account probabilities of products (doesn't work well with covarex enrichment process - so 1 fuel cell will cost 200 uranium ore)

Code: Select all

exclude = {
["used-up-uranium-fuel-cell"] = true,
}
function rawingredients(recipe) -- call this function
	if not global.best_machine then
		global.best_machine = {}
		for name, proto in pairs(game.entity_prototypes) do
			if proto.crafting_categories and proto.name ~= "player" and proto.name ~= "escape-pod-assembler" and proto.energy_usage and proto.energy_usage > 0 then
				for cat, _ in pairs(proto.crafting_categories) do
					if not global.best_machine[cat] then
						global.best_machine[cat]={speed = proto.crafting_speed or 1, energy = (proto.energy_usage or 1), name = name}
					elseif (proto.crafting_speed or 1)/(proto.energy_usage or 1) > global.best_machine[cat].speed / global.best_machine[cat].energy then
						global.best_machine[cat]={speed = proto.crafting_speed or 1, energy = (proto.energy_usage or 1), name = name}
					end
				end
			end
		end
	end
	ret = getRawIngredients(recipe,exclude)
	ret.time = (ret.time or 0)+(recipe.energy or 1)/global.best_machine[recipe.category].speed
	--ret.time = (ret.time or 0)+(recipe.energy or 1)
	ret.energy = (ret.energy or 0)+(recipe.energy or 1)/global.best_machine[recipe.category].speed*global.best_machine[recipe.category].energy
	return ret
end

function getIngredients(recipe)
	local ingredients = {}
	for i,ingredient in pairs(recipe.ingredients) do
		if (ingredient.name and ingredient.amount) then
			ingredients[ingredient.name] = ingredient.amount
		elseif (ingredient[1] and ingredient[2]) then
			ingredients[ingredient[1]] = ingredient[2]
		end
	end
	return ingredients
end

function getProducts(recipe)
	local products = {}
	if (recipe.products) then
		for i,product in pairs(recipe.products) do
			if (product.name and product.amount) then
				products[product.name] = product.amount
			elseif product.amount_min and product.amount_max then
				products[product.name] =  (product.amount_min+product.amount_max)/2 * (product.probability or 1)
			end
		end
	end
	return products
end

function getRecipes(item)
	local recipes = {}
	for i,recipe in pairs(game.recipe_prototypes) do
		if i ~="coal-liquefaction" and not (string.sub(item,-7) ~= "-barrel" and string.sub(i,-7) == "-barrel" and (string.sub(i,1,5) == "fill-" or string.sub(i,1,6) == "empty-")) then
			local products = getProducts(recipe)
			for product,amount in pairs(products) do
				if (product == item) then
					table.insert(recipes, recipe)
				end
			end
		end
	end
	return recipes
end

function getRawIngredients(recipe,excluded)
	local raw_ingredients = {
	["time"] = 0,
	["energy"] = 0}
	for name,amount in pairs(getIngredients(recipe)) do
		-- Do not use an item as its own ingredient 
		if (excluded[name]) then
			return {ERROR_INFINITE_LOOP = name}
		end
		local excluded_ingredients = {[name] = true}
		for k,v in pairs(excluded) do
			excluded_ingredients[k] = true
		end

		-- Recursively find the sub-ingredients for each ingredient
		-- There might be more than one recipe to choose from
		local subrecipes = {}
		local loop_error = nil
		for i,subrecipe in pairs(getRecipes(name)) do
			local subingredients = getRawIngredients(subrecipe, excluded_ingredients)
			if (subingredients.ERROR_INFINITE_LOOP) then
				loop_error = subingredients.ERROR_INFINITE_LOOP
			else
				local value = 0
				for subproduct,subamount in pairs(getProducts(subrecipe)) do
					value = value + subamount
				end

				local divisor = 0
				for subingredient,subamount in pairs(subingredients) do
					if subingredient ~= "intermediates" then
						divisor = divisor + subamount
					end
				end

				if (divisor == 0) then divisor = 1 end

				table.insert(subrecipes, {recipe = subrecipe, ingredients = subingredients, value = value / divisor})
			end
		end
		
		if (#subrecipes == 0) then
			if (loop_error and loop_error ~= name) then
				-- This branch of the recipe tree is invalid
				return {ERROR_INFINITE_LOOP = loop_error}
			else
				-- This is a raw resource
				if (raw_ingredients[name]) then
					raw_ingredients[name] = raw_ingredients[name] + amount
				else 
					raw_ingredients[name] = amount
				end
				
			end
		else
			-- Pick the cheapest recipe
			local best_recipe = nil
			local best_value = 0
			for i,subrecipe in pairs(subrecipes) do
				if (best_value < subrecipe.value) then
					best_value = subrecipe.value
					best_recipe = subrecipe
				end
			end

			local multiple = 0
			for subname,subamount in pairs(getProducts(best_recipe.recipe)) do
				multiple = multiple + subamount
			end

			if not raw_ingredients["intermediates"] then raw_ingredients["intermediates"] = {} end
			for subname,subamount in pairs(best_recipe.ingredients) do
				if subname == "intermediates" then
					for a, b in pairs(subamount) do
						raw_ingredients["intermediates"][a] = (raw_ingredients["intermediates"][a] or 0)+b*amount/multiple
					end
				elseif (raw_ingredients[subname]) then
					raw_ingredients[subname] = raw_ingredients[subname] + amount * subamount / multiple
				else
					raw_ingredients[subname] = amount * subamount / multiple
				end
			end 
			for a, b in pairs(getProducts(best_recipe.recipe)) do
				raw_ingredients["intermediates"][a] = (raw_ingredients["intermediates"][a] or 0)+b*amount/multiple
			end
			raw_ingredients["time"] = raw_ingredients["time"] + (best_recipe.recipe.energy or 1)/global.best_machine[best_recipe.recipe.category].speed*amount/multiple
			--raw_ingredients["time"] = raw_ingredients["time"] + (best_recipe.recipe.energy or 1)*amount/multiple
			raw_ingredients["energy"] = raw_ingredients["energy"] + (best_recipe.recipe.energy or 1)/global.best_machine[best_recipe.recipe.category].speed*global.best_machine[best_recipe.recipe.category].energy*amount/multiple
			
		end
	end

	return raw_ingredients	
end

Hey!
Can you give me hint how to run this script in v0.17? And how to extract the raw data? Thank you :)

Post by **ssilk** » Fri Aug 14, 2020 2:38 am

I think you can use this:
https://mods.factorio.com/mod/MaxRateCalculator

It says it has 0.17 support..

mdemp · Post by **mdemp** » Fri Aug 14, 2020 3:55 am

Yep, but that is not the information I was looking for. I basically need the output of that LUA script from 0.17, to do some data mining. So I was looking for a way the script would work for me. But so far Someone's LUA-Console mod didn't help in running the script, as I do not have the experience needed for it. That is why I'm asking about it here

[EDIT]
Now I guess I'm looking for the same things but in 0.18 ^_^

Factorio Forums

"Total raw" calculation

"Total raw" calculation

Re: [0.9.8] "Total raw" calculation

Re: [0.9.8] "Total raw" calculation

Re: [0.9.8] "Total raw" calculation

Re: [0.9.8] "Total raw" calculation

Re: [0.9.8] "Total raw" calculation

Re: [0.9.8] "Total raw" calculation

Re: [0.9.8] "Total raw" calculation

Re: "Total raw" calculation

Re: "Total raw" calculation

Re: "Total raw" calculation

Re: "Total raw" calculation