Ankita Das Refer ecoinvent method files and take the characterization factors for the impacts e.g. acidification, marine eutrophication or any other and use the same in your excel formulas to calulate the mid/end point impacts.

Alternatively, if any of your links have SimaPro then you can take the CFs from software as well.

Hope it helps!

You can also go through this RG link with similar question for more answers

https://www.researchgate.net/post/Has_anyone_created_a_data_base_on_excel_to_be_used_on_a_LCA_software

You will also see my detailed answer in it.

I would recomend you to use OpenLCA is a freeware software ( http://www.openlca.org/) and the EcoInvent database should be also freeware on your country ( https://www.ecoinvent.org/database/buy-a-licence/price-list/price-list.html). Excell based approaches are prone to errors and you get more reliable results wiht specialized software avaliable.

Thank you for your valuable comments.

Dear Ankita,

I think so far other people have introduced available software, i.e., openLCA, GAbi, Argonne GREET model, and so on. I have used almost all of them for a certain purpose. I remember GREET was an excel-base one, and would be a help, but just for calculations.

BUT, you need the database to perform calculations. Your calculator, excel, or any software, may help you to find out how much element is suppose to be released. But you need the ecoinvent database to translate it into ecopoints. Software use updated databases automatically. However, you can find these databases through internet sometimes.

For your question, I would say your problem would be the access to the databases. If you have access to the database, or if you have used familiar conventional materials in the production phase, excel calculation wont be a big deal.

for a step-by-step help in performing calculations, look through this book:

The Hitch Hiker´s Guide to LCA - An orientation in LCA methodology and application

This is the course book for LCA courses, teaches you how to calculate different impacts manually! and still I think the best one!

good luck!

Dear Arash,

Thank you for the help. Do you have the copy of the book, I mean in PDF?

Thanks and Regards

Ankita

Dear Anikita,

No, I'm sorry. This was the LCA course book, so we had hard copies in class.